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

Thanks

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

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

Thanks
.

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)


---
Message posted from http://www.ExcelForum.com/

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 " wrote:

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)


---
Message posted from http://www.ExcelForum.com/

Sorry... Not that I'm aware of

--
Message posted from http://www.ExcelForum.com