Thread: Error Message
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone[_2_] Jim Cone[_2_] is offline
external usenet poster
 
Posts: 1,549
Default Error Message

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