Bob -
You said public property, but I thought you demonstrated a public variable.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"Bob Phillips" wrote in message
...
Uhh, isn't that what I said 2 hours 44 minutes earlier, and the OP said
was what he was doing?
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my
addy)
"Jon Peltier" wrote in message
...
You could set up properties, which I use to pass information into and out
of the form:
http://peltiertech.com/Excel/PropertyProcedures.html
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______
"Marcus Schöneborn" wrote in message
. uni-frankfurt.de...
»Bob Phillips« wrote:
The standard way is to have a public property in the form and test that
afterwards
Dim myForm As UserForm1
If myForm Is Nothing Then Set myForm = New UserForm1
myForm.Show
MsgBox myForm.myProp
Set myForm = Nothing
In the form have a public variable
Public myProp as Boolean
and set it in the form code.
That's what I am doing at the moment. I hoped there was another way to
do that... Well, then it's fine. Thanks.