Which button was pressed?
Getting closer... thanks.
Two questions.
1. When (and how) do I unload the userform? Or do I leave
it and include some code to reset all the values before
the next .Show?
2. There is still the problem of distinguishing between
the OK and Cancel buttons. eg. the code below displays the
message whichever of those two I click.
Sub ChooseCohorts()
ChooseCohort.Show
If ChooseCohort.CheckBoxER1.Value = False Then MsgBox "Not
ER1"
End Sub
-----Original Message-----
Adrian,
I see what you mean now.
If you Unload the form, the form is cleared from memory,
so that when you do
the
If ChooseCohort.CheckBoxER1.Value = True Then MsgBox "ER1"
test it re-loads the form, but in it's initial state.
Instead of unloading the form, just hide it, it will saty
in memory tehn.
Me.Hide
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"Adrian" wrote in message
...
Sorry Bob, I don't understand.
I have written Private subs that make my userform (named
ChooseCohort) work as required.
I've summoned the dialog from a Module (see below) but
after closing the dialog nothing happens (i.e. I can
never
get the Msgbox to appear). That's one problem.
I'm calling the userform from a module (instead of
putting
the code into the userform) so that I can use the form
in
several different subs.
My other problem, and the one that I mentioned in my
first
posting, is that I want it to do nothing if the Cancel
button was the way out of the userform.
Sub Test()
ChooseCohort.Show
If ChooseCohort.CheckBoxER1.Value = True Then
MsgBox "ER1"
End Sub
-----Original Message-----
Adrian,
They would have separate click even ts so you can tell
that way.
--
HTH
Bob Phillips
... looking out across Poole Harbour to the
Purbecks
(remove nothere from the email address if mailing
direct)
"Adrian" wrote in message
...
I have a custom dialogue that I need to use in two
very
different macros. Hence my OKButton_Click routine is
empty
except for Unload UserForm, so that the calling
macros
can
each do their own thing.
But how can the calling macros tell if it was the
OKbutton
or the Cancelbutton that was pressed?
.
.
|