Problem with ComboBox and Tab key on worksheet !

  • Thread starter Thread starter tristan Brenner
  • Start date Start date
T

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
 
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)
 
Back
Top