How to declare global variable in Excel VBA?

's Computer Specifications

Dear Excel Gurus,

This may sound like a basic question, but I only know C and am new to Excel
VBA

I wish to define a global variable that is accessible to all worksheets. Can
someone advise?

Thanks.

's Computer Specifications

In a standard/regular module - not a Class module - at the top of the module...

Public Const LNG_LENGTH As Long = 123
-or-
Public lngLength as Long
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)

"Sing"
wrote in message
Dear Excel Gurus,
This may sound like a basic question, but I only know C and am new to Excel
VBA
I wish to define a global variable that is accessible to all worksheets. Can
someone advise?
Thanks.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
where and how to declare global variable in vb2005 ?	lokesh kumar	Microsoft C# .NET	1	27th Sep 2007 11:37 AM
declare a global variable	=?Utf-8?B?cmFmaWs=?=	Microsoft Access Macros	1	5th Aug 2005 02:22 AM
How to declare a variable in the global scope?	Miguel Dias Moura	Microsoft ASP .NET	41	27th Dec 2004 05:56 PM
How to declare variable as Excel constant?	John Wirt	Microsoft Excel Programming	2	22nd Aug 2004 05:41 PM
how to declare session variable in global.asax file	khawar	Microsoft ASP .NET	1	10th Jul 2003 09:03 PM