Posted to microsoft.public.excel.programming

chuckm

external usenet poster

Posts: 15

Userforms and public variables

Thanks,

I think I just solved my problem.

At the top of the Userform code module I added a Public
statement...e.g.
Public MyVariable

Then, at any place in my macros that I need to access MyVariable I do
so by:

x = MyUserform.MyVariable

Seems to work for me

thanks
chuckm

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
public variables, 2 userforms	Charlie	Excel Programming	0	December 25th 07 07:51 PM
Public Variables	[email protected]	Excel Programming	1	September 1st 05 04:14 PM
Public Variables	ExcelMonkey[_190_]	Excel Programming	5	February 21st 05 10:12 AM
Public Variables	Les Gordon	Excel Programming	2	November 11th 04 12:29 PM
Public Variables with UserForms	Mark Worthington	Excel Programming	3	February 26th 04 12:26 AM

All times are GMT +1. The time now is 10:09 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us