Posted to microsoft.public.excel.programming

Gary Keramidas Gary Keramidas is offline

external usenet poster

Posts: 2,494

preserving variable from userform

any way to preserve a variable set when an optionbutton is true, a
commandbutton is clicked and the userform hidden? doesn't seem to want to be
available after it's hidden. i know i could store it on a sheet, but didn't want
to do that. even tried a public variable and it didn't work either

--

Gary

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
Userform and variable	Jeff	Excel Discussion (Misc queries)	1	March 16th 07 03:14 PM
VBA Variable as userform	[email protected]	Excel Programming	3	April 13th 06 08:32 PM
Variable ComboBox on Userform	DHallam	Excel Programming	2	July 19th 05 12:20 PM
userform variable as global	crew3407[_6_]	Excel Programming	8	May 6th 04 04:38 PM
Passing a value to a variable from Userform	Neal Steiner	Excel Programming	1	July 18th 03 09:12 PM

All times are GMT +1. The time now is 04:07 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us