ComboBox Problems

[Darrin Henry]

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!

 

[Jim Carlock]

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.