Whats happening to my public variable?

[Mark]

Hi NG

Major problem and source of confusion for my part!

I have a module, lets call it "modA" that has a public string variable

modA {
public str as string

sub startup()
str = "Hello World"
end sub
}

Okey: Now i try to execute some line of code somewhere in my project:

msgbox modA.str

The first time, the message box will pop up with "Hello World" written in
it. The next time i execute the line, the message box will appear with an
empty string "". What is going on!! I do not get it.

Any help is greatly appreciated.
Mark

 

[Nikos Yannacopoulos]

Mark,

Not sure this is the case, but I suspect "str" is a reserved keyword for
VBA. Try to use another variable name (e.g. str1) instead, and see if this
corrects your problem.

HTH,
Nikos

 

[Mark]

It also happens if i call it something else than str.