TAB out of a combo box

  • Thread starter Thread starter Richard Edwards
  • Start date Start date
R

Richard Edwards

I have an embedded combo box on my worksheet.

when i have finished typing into it i would love to be able to <TAB> out of
it to the next cell - but it doesn't work...

am i missing a property or piece of code?

thx

richard
 
Hi Richard

Private Sub ComboBox1_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, _
ByVal Shift As Integer)
If KeyCode = 9 Then
ActiveCell.Next.Activate
'or
' Range("F3").Activate
End If
End Sub

If this helps, click the naked lady in the ad to the left. And please don't
crosspost.

Best wishes Harald
 
Back
Top