View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Declaration of public variable - Question

a public variable declared in a general module should be visible throughout
the workbook/project. Declaring it anywhere else will hide it in the
location where it is declared again.

(this assumes the module is public, but that is the default).

--
Regards,
Tom Ogilvy


"Les Stout" wrote in message
...
Hi, i am sure a simple answer, but if i declare a public variable in the
first or "Start module", does that surfice for the whole project or must
one declare it in each module?

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***