Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ComboBox Problems
Hello,
I am currently having problems with a combo box. When the user selects the desired option in the box, and goes on to other items in the sheet, the box reverts back to the previous entry. If the user clicks back to the box, it changes to display the correct selection, however, the same thing happens if they take the focus off of the box. I've checked the properties of it, and cannot find what is causing the problem. Any ideas? *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ComboBox Problems
Make sure there is nothing coded inside of the _Change event.
Sometimes I've put something in there that I've forgotten about that causes some strange problems. The same thing applies to the _Click event. I tend to use the _Click event more than the _Change event, especially with JavaScript, which has nothing to do with Excel, but if you want to see something with JavaScript using the _Click or OnMouseOver and OnMouseOut.... http://www.microcosmotalk.com/tech/scripts/ Also, if there are any other events that either clear or adjust the ListIndex of the combobox, look at the code within those events. You can do a search for the name of the combobox to find what's happening. -- Jim Carlock http://www.microcosmotalk.com Feel free to post back to the newsgroup! "Darrin Henry" wrote in message ... Hello, I am currently having problems with a combo box. When the user selects the desired option in the box, and goes on to other items in the sheet, the box reverts back to the previous entry. If the user clicks back to the box, it changes to display the correct selection, however, the same thing happens if they take the focus off of the box. I've checked the properties of it, and cannot find what is causing the problem. Any ideas? *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
aauugghhh...#div/o problems & various average formula problems | Excel Worksheet Functions | |||
fill combobox depending on selection from another combobox | Excel Discussion (Misc queries) | |||
combobox | Excel Discussion (Misc queries) | |||
combobox | Excel Programming | |||
Combobox control problems in a grouped cell | Excel Programming |