Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default User Forms - passing data between them

If you make the variable public at the top of the userform code module, then
it should work.

--
Regards,
Tom Ogilvy

"mickiedevries " wrote in
message ...
Thanks for the help, but how do I pass the information in a variable?

For instance when a radio button is selected on form1 an amount is
assigned to variable1 (but not shown on the form) and then form2 is
shown. I want form2 to be able to utilize variable1 from form1. I'm
assuming I still have to hide form1 but how do I get the value from
form1 I tried the following but it did not work:

UserForm1.Variable1.Value

Thanks Again,

Mickie


---
Message posted from http://www.ExcelForum.com/



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Passing a range to a user defined function Gary Nelson Excel Discussion (Misc queries) 1 July 19th 07 04:22 PM
passing arrays to user defined functions ramki Excel Worksheet Functions 2 February 15th 06 08:34 AM
Using User forms to enter data into lists Saar Ben-Attar Excel Programming 1 May 5th 04 05:02 PM
PASSING DATA FROM USER FORM TO EXCEL SPREADSHEET No Name Excel Programming 12 January 7th 04 01:36 PM
Passing Text from User Form to Spreadsheet Betsy[_2_] Excel Programming 1 August 6th 03 02:33 AM


All times are GMT +1. The time now is 11:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"