| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
MessageBox with tick box
Hi all,
Is there a way to have a message box to always pop up when the file is opened but with an option, by use of a tick box. To cancel popping up if ticked. But if cell "A1" is empty for the pop up to operate again until ticked again. -- Sophie |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
MessageBox with tick box
Sounds like you want a custom userform with all those controls.
-- __________________________________ HTH Bob "Sophie" wrote in message ... Hi all, Is there a way to have a message box to always pop up when the file is opened but with an option, by use of a tick box. To cancel popping up if ticked. But if cell "A1" is empty for the pop up to operate again until ticked again. -- Sophie |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
MessageBox with tick box
Ah! ok.
I shall try that way. Could give me the code for the ticker box. The rest I can do. -- Sophie "Bob Phillips" wrote: Sounds like you want a custom userform with all those controls. -- __________________________________ HTH Bob "Sophie" wrote in message ... Hi all, Is there a way to have a message box to always pop up when the file is opened but with an option, by use of a tick box. To cancel popping up if ticked. But if cell "A1" is empty for the pop up to operate again until ticked again. -- Sophie |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
MessageBox with tick box
It is just a check box, which returns a True for checked, False otherwise
If Me.chkCancle.Value Then 'etc. -- __________________________________ HTH Bob "Sophie" wrote in message ... Ah! ok. I shall try that way. Could give me the code for the ticker box. The rest I can do. -- Sophie "Bob Phillips" wrote: Sounds like you want a custom userform with all those controls. -- __________________________________ HTH Bob "Sophie" wrote in message ... Hi all, Is there a way to have a message box to always pop up when the file is opened but with an option, by use of a tick box. To cancel popping up if ticked. But if cell "A1" is empty for the pop up to operate again until ticked again. -- Sophie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Simple Yes / No messagebox followed by an if then else formula | Excel Discussion (Misc queries) | |||
| Help with MessageBox coding for newbie | Excel Worksheet Functions | |||
| messagebox in excel 2003 | Excel Discussion (Misc queries) | |||
| Prevent error messagebox when refresing querytable from the web fails | Excel Discussion (Misc queries) | |||
| Printing messagebox | Excel Discussion (Misc queries) | |||
Hybrid Mode
