Active X control

**Aland2929** · 03-14-2012, 06:32 AM

How do I select an active x control (Drop down list), when I move to the sheet that contains the control? If the cursor is in a different position and the user starts to type the first few letters of the intended selection of the drop-down list, the letters are entered in the cell where the cursor is.
Thanks in advance

**royUK** · 03-14-2012, 06:49 AM

Why are you using an ActiveX control, I would use Data validation on the sheet.

Record a macro whilst selecting the control, then adapt that code into the WorkSheet_Activation code

**Aland2929** · 03-14-2012, 07:01 AM

Thanks Roy. Data validation does not allow the user to type the first letter or letters to move to a selection quickly. I inserted the following code in the target sheet which works fine if you click the sheet, but I want to attach code to a button in a different sheet so that the list box is activated when the sheet is activated?

Private Sub Worksheet_Activate()
Listbox1.Activate
End Sub

Thanks in advance

**Aland2929** · 03-14-2012, 07:11 AM

Recording a macro does not show any code when selecting the listbox?

**Aland2929** · 03-14-2012, 08:32 AM

I have solved my problem. The original code selected a cell after the sheet was activated. If I simply activate the sheet, then the [Worksheet_Activate] code selects the Listbox.