Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
No change event on control toolbox combo box when selection is the same?
Of the three combo boxes available I generally prefer the simple Data
Validation drop down list. But in this particular use I want the same combo box to be mirrored on two sheets. Trying to get Data Validation ones to stay in sync with change events gets ugly. So for this input we had been using a Forms combo box. They work very nicely, but one can't set their background color, and we like to use yellow for input fields. This gets me to using the one in the control toolbox. I'd like it to work as close to a Forms one as possible. So after the user has made a selection I want to put the focus back on the sheet. People have come up with various ways to do this. The one I've been using is Private Sub ComboBox1_Change() SendKeys "{ESC}" End Sub But in the combo box I'm working with now, if the user leaves the selection the same it doesn't fire this macro and the focus remains on the control. I have Style=DropDownList. MatchRequired=True. MatchEntry=Complete. AutoWordSelect=True. EnterFieldBehavior=SelectAll. Is there any way to get the behavior I want? Don <donwiss at panix.com. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
what is code to activate a combo box in control toolbox | Excel Discussion (Misc queries) | |||
combo box from control toolbox | Excel Discussion (Misc queries) | |||
control toolbox combo box | Excel Discussion (Misc queries) | |||
Selection Change Event... | Excel Programming | |||
Help with a Combo Box Change Event | Excel Programming |