Need Code Translated to Basic

[mrstuff68]

I have the following macro in MS Excel, i need it translated into Basic so that i can run the same macro on Open Office.

Can anyone help.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$2" Then
Dim Msg, Style, Title, Response
Msg = "Do you want to update YTD?"
Style = vbYesNo + vbQuestion
Title = "Earnings"
Response = MsgBox(Msg, Style, Title)
If Response = vbNo Then
Exit Sub
Else
[d2].Formula = [d2].Value + [c2].Value
End If
End If
End Sub

[Hack]

Visual Basic?

[mrstuff68]

I dont know what basic, i dont think it is visual basic. When i go into Open Office the editor just says Basic. This is my first time using Open Office yet alone write a macro, and if i put in my excel macro in it, it doesnt work.

[techgnome]

I don't think it's a Basic language.... I think it means Basic mode vs. Advanced mode... ???

Tg

[Hack]

What is "Open Office"?

I'll see if I can find something that might point you in the right direction.

[mrstuff68]

Open Office, is like a freeware version of MS Office. Its just like MS Office it opens up all the documents that are generated in MS Office, but it is free. Seems to me its like Linux is an alternative to Windows.

[techgnome]

It's cross platform... I use ot at home from time to time. http://openoffice.org -- it's lineage comes from StarOffice from Sun. They took a basline of it, shifted it over to open source, renamed it OO. Now it's run by a group much the same way Mozilla/Fx is run.

Tg