MessageBox with tick box

[Sophie]

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.

 

[Bob Phillips]

Sounds like you want a custom userform with all those controls.

 

[Sophie]

Ah! ok.
I shall try that way.
Could give me the code for the ticker box. The rest I can do.

 

[Bob Phillips]

It is just a check box, which returns a True for checked, False otherwise

If Me.chkCancle.Value Then

'etc.