Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Just two ideas:
1) Deactivate the button after you've clicked it and activate again it after you've closed the Msgbox. 2) Declare a global boolean variable, say BtnClicked. Start by setting BtnClicked as False. In your Button1_Click procedure, set BtnClicked to True. Based on that, conditionally disable parts of the procedure as needed. And with the message box, if the user clicks OK, reset the boolean variable back to False. Hope that helps, Anony |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
2007 Form Control/ActiveX Control font difference | Excel Discussion (Misc queries) | |||
publish activeX combobox and other activeX control | Excel Programming | |||
Help with using an activex control | Excel Programming | |||
Loop with activeX optionbuttons. | Excel Programming | |||
How to control "Date Time Picker ActiveX Control" | Excel Programming |