Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a userform with commandbuttons, a listbox, Labels, a combobox, and
textboxes. When I am using it, I get a "Microsoft Forms" "Invalid Propery Value" error. It does't boot me out but everything I click gets the same error. It only happens when I do a certain sequence. It also goes away when I select an item from the combobox. What do I need to look at to try to fix this? Thanks |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() In the VBE... Tools | Options | General (tab) | Break on All Errors Then run your code. You will quickly find out where the error occurs. -- Jim Cone Portland, Oregon USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins...Rows to Repeat at Bottom has a free trial) "ranswrt" wrote in message I have a userform with commandbuttons, a listbox, Labels, a combobox, and textboxes. When I am using it, I get a "Microsoft Forms" "Invalid Propery Value" error. It does't boot me out but everything I click gets the same error. It only happens when I do a certain sequence. It also goes away when I select an item from the combobox. What do I need to look at to try to fix this? Thanks |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I tried that and nothing happened except the error message.
"Jim Cone" wrote: In the VBE... Tools | Options | General (tab) | Break on All Errors Then run your code. You will quickly find out where the error occurs. -- Jim Cone Portland, Oregon USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins...Rows to Repeat at Bottom has a free trial) "ranswrt" wrote in message I have a userform with commandbuttons, a listbox, Labels, a combobox, and textboxes. When I am using it, I get a "Microsoft Forms" "Invalid Propery Value" error. It does't boot me out but everything I click gets the same error. It only happens when I do a certain sequence. It also goes away when I select an item from the combobox. What do I need to look at to try to fix this? Thanks |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Before running your code...
Unlock/unprotect your project. Leave the VBE window open. Run your code and when you get the error activate the VBE and the offending code line should be highlighted. -- Jim Cone "ranswrt" wrote in message I tried that and nothing happened except the error message. "Jim Cone" wrote: In the VBE... Tools | Options | General (tab) | Break on All Errors Then run your code. You will quickly find out where the error occurs. -- Jim Cone Portland, Oregon USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins...Rows to Repeat at Bottom has a free trial) "ranswrt" wrote in message I have a userform with commandbuttons, a listbox, Labels, a combobox, and textboxes. When I am using it, I get a "Microsoft Forms" "Invalid Propery Value" error. It does't boot me out but everything I click gets the same error. It only happens when I do a certain sequence. It also goes away when I select an item from the combobox. What do I need to look at to try to fix this? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
replace VBA run-time error message with custom message | Excel Programming | |||
error message: compile error, argument not optional | Excel Programming | |||
Excel XP error message Run Time Error 91 | Excel Programming | |||
changing the message in an error message | Excel Worksheet Functions | |||
How do I get rid of "Compile error in hidden module" error message | Excel Discussion (Misc queries) |