Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
message box question
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Message box question | Excel Discussion (Misc queries) | |||
Message Box - Quick Question | Excel Discussion (Misc queries) | |||
Simple message box question | Excel Discussion (Misc queries) | |||
question about creating a message box | Excel Programming | |||
message box/question box in a formula | Excel Programming |