Thread: Public variable
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Eric[_35_] Eric[_35_] is offline
external usenet poster
 
Posts: 26
Default Public variable

Hello,

I am setting up a public variable in the declaration section of my module
(Public Authorized_Machine as string)
I initialize the variable right in the Auto_open() sub expecting ths
variable and its value to be available to all the procedures in my module,
but it does not work.
A simple "MsgBox Authorized_Machine" (in a seperate procedure) shows the
variable empty...

What am I doing wrong?

Thank you.

Eric