Global/Static Variables

matthewh · Mar 19th, 2002, 08:04 AM

How do I decare a Global variable that will be available to the entire workbook as a static. I need to procuce a lot of the same sheet with 2 name changes on each one, but the names are used throughout the code. It's easier to change 2 variables than go through the code and do it that way.

Dave Hawley · Mar 19th, 2002, 08:35 AM

Hi

At the very top of standard module use:

Public Const MyNum As Integer = 256

Juan Pablo González · Mar 19th, 2002, 09:42 PM

Dave "teaches" how to add a public constant, but if you need a variable, use this:

Public MyNum As Integer

That will be available to all modules

Mar 19th, 2002, 09:42 PM	#3
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	Dave "teaches" how to add a public constant, but if you need a variable, use this: Public MyNum As Integer That will be available to all modules __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 19th, 2002, 08:04 AM	#1
matthewh New Member Join Date: Mar 2002 Posts: 34	How do I decare a Global variable that will be available to the entire workbook as a static. I need to procuce a lot of the same sheet with 2 name changes on each one, but the names are used throughout the code. It's easier to change 2 variables than go through the code and do it that way.

Mar 19th, 2002, 08:35 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi At the very top of standard module use: Public Const MyNum As Integer = 256