Posted to microsoft.public.excel.programming

external usenet poster

Posts: 703

public variables, 2 userforms

I set ws1 as sheet1 or sheet2 on Userform1.
I need to reference ws1 on Userform2, but it doesn't seem to recognize ws1.
How do I make ws1 public to all forms? I just have Public ws1 as Worksheet
before my code on Userform1
thanks.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to 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	johnny	Excel Discussion (Misc queries)	7	February 27th 08 03:44 PM
Public variables	Tomski[_28_]	Excel Programming	3	August 10th 06 03:19 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 03:58 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us