Passing variables or arrays to userforms 
Author Message
 Passing variables or arrays to userforms

Hi I have had a great deal of difficulty trying to pass arrays or
variables to a userform
when i  load or call it. In the documentation for user forms it says
they are objects and can as such be passed values. when i try this it
accepts the variables. It flags an error when run though. it makesw
sense that there should be a way to receive the data within the form
like you would when writing a function or sub but their is no reference
or example of this in the help files. Any ideas, send me an example or
help reference. Thanks Much Rob B.


Wed, 18 Jun 1902 08:00:00 GMT  
 Passing variables or arrays to userforms

Quote:

> trying to pass arrays or
> variables to a userform
> when i  load or call it. In the documentation for user forms it says
> they are objects and can as such be passed values. when i try this it
> accepts the variables. It flags an error when run though. it makesw
> sense that there should be a way to receive the data within the form
> like you would when writing a function or sub but their is no reference
> or example of this in the help files.

There is no way to pass information on the Show method.
You can set public variables in the module of the form as if they were
properties of the form - that may be what you are thinking of.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply to newsgroup



Wed, 18 Jun 1902 08:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Passing arrays to and from userforms

2. Passing variables between userforms and/or normal procedures

3. pass a variable array from oneuser form to another

4. Passing variables or arrays to userform objects

5. Pass array variable to a function

6. Passing Texbox/combobox values to a macro, calling a stored procedure and passing these variables

7. Passing Variable off Form to SQL Pass Through Query

8. Reading a variable range on a spreadsheet into a variable array

9. Passing variables vs. using Public variables

10. Passing VB/A variables to query variables


 
Powered by phpBB® Forum Software © phpBB Group