Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
You could lookup the value of the onchange event and change it to the
combobox: ---------------------------------------- Private Sub Worksheet_SelectionChange(ByVal Target As Range) Select Case Target.Address Case Is = "$B$2" ComboBox1.Activate Case Is = "$B$4" ComboBox2.Activate End Select End Sub ---------------------------------------- Adjust the ranges and the ComboBox-names. If there are a lot of comboboxes it'll be a little complex. This code has to be inserted in the Worksheet module you want the code to work. To do that, right click on the Worksheet-tab and click "View Code..." hth Carlo On Dec 10, 4:35 pm, Pam wrote: I have a worksheet with several combo boxes and the work great as far as typing in the first letter and it auto completing. My problem is, many of our users want to "tab" to the next field, and they get in the field, but they don't actually select the combo box until they mouse click on it. Is there some way I can set this so that they can tab to it and actually select the combobox instead of the cell behind it? Thanks for any help you can give me |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Combo box update to field | Excel Discussion (Misc queries) | |||
How to select one of three lists for a combo box? | Excel Programming | |||
change field format for combo box | Excel Programming | |||
Select Method from Combo Box | Excel Programming | |||
How do I set up a combo box to select one value but pas an other . | Excel Programming |