ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   MsgBox - Don't Show Again (https://www.excelbanter.com/excel-programming/307518-msgbox-dont-show-again.html)

Exceller

MsgBox - Don't Show Again
 
Anyone know how to insert that checkbox in repetitive msgboxes which, if you
select, the msgbox will not show again?

Thanks

GJones

MsgBox - Don't Show Again
 
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
.


E_R[_3_]

MsgBox - Don't Show Again
 
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/


Exceller

MsgBox - Don't Show Again
 
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/



E_R[_5_]

MsgBox - Don't Show Again
 
Sorry... Not that I'm aware of

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



All times are GMT +1. The time now is 03:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com