Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA MsgBox close button has changed...
I have been building custom forms and using regular MsgBoxes and
VBYesNo styles. However, after testing some of the modal properties, etc., all of a sudden my close buttons' color has changed. The close buttons for regularly created forms and MsgBoxes look fine, but the MsgBoxes using VBYesNo look as follows: http://www.dslextreme.com/users/madf...loseButton.jpg Please advise. Paul |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA MsgBox close button has changed...
hi
the close button may be disabled so that you can only select vbyes or vbno. wild guess here. regards FSt1 " wrote: I have been building custom forms and using regular MsgBoxes and VBYesNo styles. However, after testing some of the modal properties, etc., all of a sudden my close buttons' color has changed. The close buttons for regularly created forms and MsgBoxes look fine, but the MsgBoxes using VBYesNo look as follows: http://www.dslextreme.com/users/madf...loseButton.jpg Please advise. Paul |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA MsgBox close button has changed...
Thanks for the reply.
I wondered that at first, but the button closes as expected. I think I messed with a MsgBox object/property and would love to return it to the normal red X button. Paul On Jul 18, 8:16*pm, FSt1 wrote: hi the close button may be disabled so that you can only select vbyes or vbno. wild guess here. regards FSt1 " wrote: I have been building custom forms and using regular MsgBoxes and VBYesNo styles. However, after testing some of the modal properties, etc., all of a sudden my close buttons' color has changed. *The close buttons for regularly created forms and MsgBoxes look fine, but the MsgBoxes using VBYesNo look as follows: *http://www.dslextreme.com/users/madf...loseButton.jpg Please advise. Paul- Hide quoted text - - Show quoted text - |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA MsgBox close button has changed...
That is completely normal behaviour of the messagebox.
Sub test() MsgBox "just testing", vbYesNo + vbQuestion, "vbYesNo + vbQuestion" MsgBox "just testing", vbYesNoCancel + vbQuestion, "vbYesNoCancel + vbQuestion" End Sub RBS wrote in message ... I have been building custom forms and using regular MsgBoxes and VBYesNo styles. However, after testing some of the modal properties, etc., all of a sudden my close buttons' color has changed. The close buttons for regularly created forms and MsgBoxes look fine, but the MsgBoxes using VBYesNo look as follows: http://www.dslextreme.com/users/madf...loseButton.jpg Please advise. Paul |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA MsgBox close button has changed...
RBS,
Yes, I stand corrected; I checked on another system, and it behaves as you've eluded. I'm glad that I didn't corrupt things. Thanks much, Paul On Jul 18, 10:02*pm, "RB Smissaert" wrote: That is completely normal behaviour of the messagebox. Sub test() * MsgBox "just testing", vbYesNo + vbQuestion, "vbYesNo + vbQuestion" * MsgBox "just testing", vbYesNoCancel + vbQuestion, "vbYesNoCancel + vbQuestion" End Sub RBS wrote in message ... I have been building custom forms and using regular MsgBoxes and VBYesNo styles. However, after testing some of the modal properties, etc., all of a sudden myclosebuttons' color has changed. *Theclosebuttons for regularly created forms and MsgBoxes look fine, but the MsgBoxes using VBYesNo look as follows: http://www.dslextreme.com/users/madf...loseButton.jpg Please advise. Paul- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Msgbox Close with vba | Excel Programming | |||
Msgbox Close Button | Excel Programming | |||
Close msgbox ? | Excel Programming | |||
Excel shoud not close all active books when clicking close button | Excel Discussion (Misc queries) | |||
excel - Windows close button (x) should only close active workboo. | Setting up and Configuration of Excel |