Problem with ComboBox and Tab key on worksheet !

[tristan Brenner]

Hello,

I have two combobox on worksheet1.
I choose a value in combobox1 and with the TAB key I want to set focus on
the second combobox .
How can I do ? Thank you

Private Sub ComboBox1_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal
Shift As Integer)
If KeyCode = 9 Then ????? ( ComboBox2.Activate, ComboBox2.SetFocus,
...... )
End Sub

 

[Bob Phillips]

Hi Tristan,

Difficult, as there is no built-in to do this, but it can be done. Here is a
previous post that I gave that discusses it. It is presented as code for
textboxes but it works equally well for comboboxes, or a mixture. By the
way, I have tried it since I posted this, it works.

http://tinyurl.com/26jan


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[tristan Brenner]

Thanks for your help Bob.