LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 367
Default tab to select combo box instead of field?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combo box update to field Esrei Excel Discussion (Misc queries) 1 June 26th 07 03:01 PM
How to select one of three lists for a combo box? Ingeniero1[_6_] Excel Programming 2 April 16th 06 07:33 PM
change field format for combo box wAyne Excel Programming 0 March 10th 06 09:01 PM
Select Method from Combo Box bw Excel Programming 6 August 25th 05 11:47 PM
How do I set up a combo box to select one value but pas an other . exkiller Excel Programming 1 January 4th 05 07:06 PM


All times are GMT +1. The time now is 08:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"