Differences in References from 97 to XP

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I need to know the difference between the Global
Declaration for variables in XP and 97 and the difference
in IsNull.

What do I use instead in XP?

Thanks for your help

-Chris
 
I need to know the difference between the Global
Declaration for variables in XP and 97 and the difference
in IsNull.
Click to expand...

I don't see any difference. What do you think has changed?

Tim F
 
-----Original Message-----


I don't see any difference. What do you think has changed?

Tim F

.
Click to expand...

I am using an app called Office Converter and it does it
says Office XP does not recognize the words GLOBAL and
ISNULL which was written in 97

-Chris
 
I am using an app called Office Converter and it does it
says Office XP does not recognize the words GLOBAL and
ISNULL which was written in 97
Click to expand...

This code seems to do exactly what I expect in a module in Excel 2002,

Option Explicit

Global g_varAny As Variant

Public Sub Test()

If IsNull(g_varAny) Then g_varAny = 3

End Sub

It seems that the Global keyword has been superceded by Public but it still
works; and I can't think of what might be wrong with IsNull().

You might ask the supplier?

Tim F
 
Back
Top