MsgBox - Don't Show Again

[Guest]

Anyone know how to insert that checkbox in repetitive msgboxes which, if you
select, the msgbox will not show again?

Thanks

 

[GJones]

Hi exceller;

I'm not sure exactly what you are doing but in general the
first time you run the box you can capture whether or not
they checked it and use a varialbe to hold the answer for
the rest of the routine.

You could also write the results to a cell in a sheet and
then read it each time to see if the check box should be
shown again.

Hope that helps,

Greg

 

[E_R]

You'll need to create your own dialogs from userforms with checkboxes on
them, then store the checkbox value - say in the registry (Look at the
Savesetting and GetSetting registry functions)

 

[Guest]

Yes I know it is simple enough to do this with userforms.

However, it would be handy if there was a quick way of inserting that option
in a standard msgbox to save time and space.

 

[E_R]

Sorry... Not that I'm aware of