Re: Re : Global Variable

The Frog

Guest

Posts: n/a

23rd May 2007

Hi BB206,

Have you tried making adding a module to the project, and then in this
module declaring the variables and arrays you need as PUBLIC? This has
worked for me for ages.

I usually make the module name GLOBALS so that I can identify it
easily, then just dim the vars like this: PUBLIC strTestString as
String. Use the public keyword to make sure the scope of the variable
allows the variable to be seen / used by other modules and code.

Hope this helps

Cheers

The Frog

« Re: Re : Global Variable | Re: Re : Global Variable »

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

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
select offset (variable ,1) to offset(variable ,variable)	Buffyslay	Microsoft Excel Programming	1	15th Nov 2006 12:45 PM
why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel?	Daniel	Microsoft Excel Worksheet Functions	1	9th Jul 2005 03:05 AM
why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel?	Daniel	Microsoft Excel Discussion	1	9th Jul 2005 01:04 AM
how to set a 'global' variable in global.asax	Jason Shohet	Microsoft C# .NET	2	19th Apr 2004 08:43 PM
Global Error handling in Applicatio_Error() of Global.asax	VSK	Microsoft ASP .NET	1	29th Jul 2003 04:12 AM