Posted to microsoft.public.excel.programming

Tim Williams (Theravance) Tim Williams (Theravance) is offline

external usenet poster

Posts: 5

Declaring a local variable once for all subs

If you create a variable which is globally accessible it can only have
one value at any given time. If you need local values then you need
local declarations....

Tim

On Sep 29, 4:11*am, Poniente wrote:
Hi,
I'd like to declare a variable once in an referenced xla file, in a
way that all the individual subs in the referring workbook can give it
a local value.
Is this possible?

Regards, Poniente

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
Declaring subs Public vs Private	Rick	Excel Programming	9	December 19th 07 12:30 AM
Declaring a tab name as a variable	timmulla	Excel Programming	2	January 25th 07 05:16 AM
Declaring a tab name as a variable	timmulla	Excel Programming	0	January 25th 07 03:26 AM
How to declare a variable for several subs	David	Excel Programming	17	May 18th 05 06:38 PM
Declaring a variable?	pgoodale[_4_]	Excel Programming	2	January 2nd 04 03:26 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us