Thread: Varible scope
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Varible scope

Declare the variable outside of and before any procedure declaration. Use
"Public" instead of "Dim" if you want to variable to be visible from any
module (not just the module in which it is declared) or use "Private"
instead of "Dim" if you want the variable to be visible only from within the
module in which it is declared.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)



"miek" wrote in message
...
Is it possible to declare a varible that can be seen (availble) from any
Sub(routine) within the current Module1?

If so How