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
