View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mark[_36_] Mark[_36_] is offline
external usenet poster
 
Posts: 39
Default referencing at module level

Hi NG

I have a small problem with referencing a public variable in a module

Module A:
public strXML as string

Module B:
sub something
msgbox "String: " & A.strXML
end sub

My problem is that the first time a run the above everything works fine, but
the second time i run it then strXML = "". Like it has been flushed somehow.
I tried it with other objects too, and the same accured.

Does anyone know what is going on and how to fix it?

Mark