PDA

View Full Version : Open Office Basic



lsutiger
February 7th, 2008, 11:33 PM
I have some, well really many, projects that were done with MS Excel and VBA.

The equivalent is Open Office Basic.

I am running into a brick wall.

Here is the lines of code:

myCheck = MsgBox("Rankings already calculated for today. Recalculate?", vbYesNo)
(this is where the error is) If myCheck = vbNo Then Exit Sub

The error I get is "Basic runtime error 91","Object variable not set."

Do I have to use other variables for vbNo and vbYes?

Thanx in advance