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

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

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

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