message box question
 

hi

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

message box question
 

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


"mark" wrote in message
...
hi

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

message box question
 

What type of message do you not want to see again?



--
Message posted from http://www.ExcelForum.com

message box question
 

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)

"mark" wrote in message
...
hi

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

message box question
 

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


"mark" wrote in
message
...
hi

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


.