message box question

M

mark

hi

just wondering if there's a way to set up 'never show this
message again' kind of thing in excel vba code.
thanks
 
O

Olly

You could look at the value of a (maybe hidden?) cell before opening a
userform, and change the value of this cell if a 'never show again' option
is checked.

e.g., to call the form if wanted:

=
If MyCell.Value <> True Then MyUserForm.Show
=

Add a line in the UserForm_QueryClose event:

=
MyCell.Value = MyUserForm.MyCheckBox.Value
=
 
B

Bob Phillips

Mark,

One way would be to create a userform that shows the message as a label, and
also has the 'Never show' text below with a checkbox. If the checkbox is
checked, create a named range with a value of True say. Always check this
value to see whether to show the form, something like

If Range("NeverShow").Value = FALSE Then
myMessageForm.Show
End If

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
M

mark

wow thanks. never thought of that
-----Original Message-----
You could look at the value of a (maybe hidden?) cell before opening a
userform, and change the value of this cell if a 'never show again' option
is checked.

e.g., to call the form if wanted:

=
If MyCell.Value <> True Then MyUserForm.Show
=

Add a line in the UserForm_QueryClose event:

=
MyCell.Value = MyUserForm.MyCheckBox.Value
=


--
Olly





.
Click to expand...
 
Top