Posted to microsoft.public.excel.programming

external usenet poster

Posts: 11

Create Global Variables in a module

Is it possible to set variables for access to all sub routines and functions within a module?

eg. pathB = ThisWorkbook.Path is refer to this in many sub routines

Bruce

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 module	Al	Excel Programming	2	April 30th 04 12:02 PM
Global variables cleared by forms?	Stu[_33_]	Excel Programming	4	February 29th 04 04:33 PM
Global Variables using User Forms	Steve[_53_]	Excel Programming	4	January 31st 04 02:38 AM
Global Variables Not Accessible	John Baker	Excel Programming	5	November 28th 03 01:23 AM
Declaring Global Variables	skmr3	Excel Programming	1	July 14th 03 05:54 AM

All times are GMT +1. The time now is 06:17 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us