ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   MsgBox "Invalid property value" (https://www.excelbanter.com/excel-programming/334602-msgbox-invalid-property-value.html)

Excelente[_5_]

MsgBox "Invalid property value"
 

I have a dialog box that gives me an error message when closing. It's
with two drop-down boxes and the message it get is exactly the
equivalent of:

MsgBox "Invalid property value.", vbExclamation, "Microsoft Forms"

I can't seem to de-bug it either as the error occurs before the
userform closer event runs. ugh. I'm at a loss. I have left
instructions on how to re-generate the error message right on the
splash sheet (first sheet). If anyone can help, it would be
appreciated. I tried to replying to another thread by don wiss as he
had a similar problem but no one could help either of us out.

Any takers? :confused:

I have tested in both xl2003 & xlxp. Attached is the workbook.


+-------------------------------------------------------------------+
|Filename: Bad_Dialog_Error_Message.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3600 |
+-------------------------------------------------------------------+

--
Excelente


------------------------------------------------------------------------
Excelente's Profile: http://www.excelforum.com/member.php...o&userid=23887
View this thread: http://www.excelforum.com/showthread...hreadid=387380



All times are GMT +1. The time now is 02:51 AM.

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