If worst comes to worst, you could always store any such data in the
workbook itself.

I wouldn't characterize that technique as something one would do if "worst
comes to worst". I've done that on more than a few occasions when I needed
to store a value and couldn't run the risk of globals getting wiped out by
the user monkeying around in the VBE. If you need to be certain that a
variable won't be wiped out of memory, you need to store it in a worksheet
cell, a defined name, or the registry. As long as you're not storing huge
number of variables in a sheet, to the point where performance would be
noticeably degraded, there's really nothing wrong at all with storing temp
data in a worksheet. Just make the sheet xlVeryHidden so the user can't
screw it up, and its a perfectly legitimate technique.



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com
(email address is on the web site)


"Randy Harmelink" wrote in message
oups.com...
If worst comes to worst, you could always store any such data in the
workbook itself. Something akin to a "Settings" worksheet.

On Nov 5, 7:59 pm, wrote:

Is there a way to actually create a global variable - that could be
used regardless of what a user presses?