View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Olly[_6_] Olly[_6_] is offline
external usenet poster
 
Posts: 5
Default 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