Posted to microsoft.public.excel.programming

ranswrt

external usenet poster

Posts: 191

passing data

Thanks

"Joel" wrote:

You userform is private

You need to delcare the array outside the sub as public. Remove any
declarations inside your subs where the array is being used.

Public abc(10)

"ranswrt" wrote:

I have an array that collects data using a userform. How do I pass that
array to another userform to use?
Thanks

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
Help with passing data	Mekinnik	Excel Programming	0	January 31st 08 06:02 PM
Passing data between Userforms	Coza	Excel Programming	1	March 24th 07 02:14 PM
Passing data between spreadsheets	Kat[_5_]	Excel Programming	1	November 4th 03 09:59 PM
Passing Data to Outlook	Jason[_19_]	Excel Programming	0	August 26th 03 06:57 AM
passing data from one sheet to another	billabong	Excel Programming	4	July 13th 03 01:15 AM

All times are GMT +1. The time now is 10:38 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us