Variables...the passing of.

  • Thread starter Thread starter Les
  • Start date Start date
L

Les

I have discovered I can call a previously written event code from a new one
simply by repeating the name of that routine. Obvious, I guess, for a
programmer, but nice to discover for a beginner.
My question is: I dim a variable in the first routine, then call the
second. But, the VB error box always appears with:

"Compile error: Variable not defined."

If I dim the variable in the second routine, it loses the value it was
assigned from the first routine.
How do I pass the value of a variable from one event code (routine) to
another? Or can variables only be recognized within the same routine?

Les
 
Hi Les,

You can declare the variable at the module level and it
then becomes available to the whole application, as in:

Public MyVar As String 'or whatever

you can then use this anywhere.

Variables have scope and lifetime, that is they retain
their values depending on where/how they are declared.

Search VBA help for 'lifetime' or 'scope' for some more
info.

hth

chas
 
Hi Les,

I replied earlier but my post appears to have gone astray,
apologies if it appears and gives a duplicate reply.

You can define a variable in the declarations section of a
module (outside of any routines) that can have global
scope. For example:

Public MyVar As String 'or whatever datatype

this variable is then usable from any routine.

For more information search VBA help for 'lifetime'
or 'scope' (without the quotes.

hth

chas
 
Back
Top