Accessing Global Variables in an Excel formula

[briggy]

Hi,

I have the following Global Variable defined :

Public MyVar as Integer


I have set the value of this in a Macro.

I now wish to access the value of this in a 'IF' statement e.g. if(MyVar=10, 10, "Not 10")

Is this possible? If so, what is the syntax within the IF statement?

Many thanks.

[Jakobshavn]

Put it in a cell:

Please Login or Register  to view this content.

[briggy]

That does exactly what I wanted. Thanks very much for your help.