Posted to microsoft.public.excel.programming

Don[_11_]

external usenet poster

Posts: 2

Global variable

Is there any way to have the same variable available to a
worksheet function (e.g. button_click) and a sub
procedure in a code module. I need to have the same
variable (an index in a for loop) available to both. Any
thoughts?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 variable	dhstein	Excel Discussion (Misc queries)	2	October 30th 09 01:03 PM
Global Variable	dhstein	Excel Discussion (Misc queries)	4	July 26th 09 05:10 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	Excel Worksheet Functions	1	July 9th 05 03:05 AM
I Need VBA Assistance for global variable question	Brent E	Excel Discussion (Misc queries)	1	March 1st 05 08:46 PM
Global Variable -- Excel / VBA	Adam1 Chicago	Excel Discussion (Misc queries)	3	February 23rd 05 12:03 AM

All times are GMT +1. The time now is 08:42 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us