Thread: Varible scope
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Varible scope

At the top of the module:
Dim myVar as Variant 'or whatever.

Use:
Public myVar as Variant
If you want it seen in all modules.

miek wrote:

Is it possible to declare a varible that can be seen (availble) from any
Sub(routine) within the current Module1?

If so How


--

Dave Peterson