Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 196
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Message box question WH99 Excel Discussion (Misc queries) 5 April 5th 08 12:41 AM
Message Box - Quick Question slow386 Excel Discussion (Misc queries) 2 April 30th 07 02:13 PM
Simple message box question zeyneddine Excel Discussion (Misc queries) 1 August 14th 06 08:23 PM
question about creating a message box slim[_2_] Excel Programming 3 February 25th 04 03:37 PM
message box/question box in a formula test80 Excel Programming 1 December 7th 03 07:50 PM


All times are GMT +1. The time now is 07:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"