View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
hcova[_2_] hcova[_2_] is offline
external usenet poster
 
Posts: 3
Default = How to setup vars when a workbookopen event is launched?

I need to setup some variables in my VBA code before the program starts. I
think one could to include this setup in the Workbook_Open event, before the
worksheet be loaded. How Can I do this? Second: does VBA support "Typed
Constants" like Delphi or C? For example I would like to initialize a global
(public) boolean var called FirstTime as True, so when the first macro code
starts running it has this True value by default.