I've seen that one usually runs Me.Hide inside the OK_Click or
Cancel_Click method, but is it somehow possible to specify a return
value the Show method will return, like MsgBox does for example? Also,
is it possible to specify arguments to UserForm.Show so that the form
knows how to initialize itself, without having to make an extra code
module that's just there to show the dialog?

Or is it perhaps possible to have a public "static" function inside a
Dialog module that one can call at any time and that does the creation
of the dialog? I didn't succeed when I tried to define a function there
and call it from outside.

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.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Marcus Schöneborn" wrote in message
. uni-frankfurt.de...
I've seen that one usually runs Me.Hide inside the OK_Click or
Cancel_Click method, but is it somehow possible to specify a return
value the Show method will return, like MsgBox does for example? Also,
is it possible to specify arguments to UserForm.Show so that the form
knows how to initialize itself, without having to make an extra code
module that's just there to show the dialog?

Or is it perhaps possible to have a public "static" function inside a
Dialog module that one can call at any time and that does the creation
of the dialog? I didn't succeed when I tried to define a function there
and call it from outside.

»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.

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.

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.

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.