Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions
|
|||
|
|||
TAB out of a combo box
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 |
#2
Posted to microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions,microsoft.public.excel
|
|||
|
|||
TAB out of a combo box
Hi,
You can exit a Control Toolbox Combobox by pressing Esc. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Richard Edwards" wrote: 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 |
#3
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions
|
|||
|
|||
TAB out of a combo box
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 "Richard Edwards" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
linking a form combo box... results from the combo box to another | Excel Discussion (Misc queries) | |||
combo reference on another combo box for picking address etc. | Excel Worksheet Functions | |||
Can one combo box control the data in a different combo box | Excel Discussion (Misc queries) | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) |