Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default global variables

How can I set the default value of a global variable?

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default global variables

You can initialize a constant:

Const Myvar As Long = 6

but for a variable, you would need to run a procedure to initialize it.

--
Regards,
Tom Ogilvy


wrote in message
oups.com...
How can I set the default value of a global variable?



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default global variables

yar! oh well thanks!

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,119
Default global variables

Intitilize the variable in the Workbook open procedure... Then it will be
intialized from the moment the sheet is opened...
--
HTH...

Jim Thomlinson


" wrote:

yar! oh well thanks!


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Global variables - where do you place them? CRayF Excel Programming 16 September 28th 05 01:14 AM
Global Variables Ernst Guckel[_4_] Excel Programming 2 May 7th 05 11:10 PM
Global vs Local variables Ken Loomis Excel Programming 1 October 12th 04 05:03 AM
Global Variables Not Accessible John Baker Excel Programming 5 November 28th 03 01:23 AM
Declaring Global Variables skmr3 Excel Programming 1 July 14th 03 05:54 AM


All times are GMT +1. The time now is 07:02 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"