Move to combo box

[cshetty]

Dear Experts

I have a combo box in sheet to select the value from drop down .

Is there a way to activate combo box without using the mouse.

e.g. Comb box is placed at the top of the sheet. If I am entering some data , let us say at row 10, and I want to move back to comb box to select a new value, do I need to mouse or is there any keyboard shortcut ?

Thanks in advance.

 

[James006]

Hi,

You could test

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Target.Address = "$A$10" Then Me.ComboBox1.Activate
Cancel = True
End Sub