global variables

How can I set the default value of a global variable?

You can initialize a constant:

Const Myvar As Long = 6

but for a variable, you would need to run a procedure to initialize it.

--
Regards,
Tom Ogilvy


<Kooshesh@gmail.com> wrote in message
news:1132169884.163004.293840@o13g2000cwo.googlegroups.com...
> How can I set the default value of a global variable?
>

yar! oh well thanks!

Intitilize the variable in the Workbook open procedure... Then it will be
intialized from the moment the sheet is opened...
--
HTH...

Jim Thomlinson


"Kooshesh@gmail.com" wrote:

> yar! oh well thanks!
>
>