A
afiack
I have several Toolbox Control comboboxes & text boxes on an excel sheet
that need to be used interacted with in sequence (from cboSecurity to
cboCoupon). I would like to tab from one embedded form to the next but
they do not have that ability built in. I have been trying to catch the
keypress event and process the KeyCode value:
Private Sub cboSecurity_KeyDown(ByVal KeyCode As MSForms.ReturnInteger,
ByVal Shift As Integer)
If KeyCode = 9 Then
Sheets("Trade").cboCoupon.Select
End If
End Sub
The selection occurs, but it is selected as if you were in design mode.
What I am trying to achieve is selecting the next combobox (cboCoupon)
and have the cursor be in the box so I can navigate the list by using
the keyboard arrows. Any ideas?
that need to be used interacted with in sequence (from cboSecurity to
cboCoupon). I would like to tab from one embedded form to the next but
they do not have that ability built in. I have been trying to catch the
keypress event and process the KeyCode value:
Private Sub cboSecurity_KeyDown(ByVal KeyCode As MSForms.ReturnInteger,
ByVal Shift As Integer)
If KeyCode = 9 Then
Sheets("Trade").cboCoupon.Select
End If
End Sub
The selection occurs, but it is selected as if you were in design mode.
What I am trying to achieve is selecting the next combobox (cboCoupon)
and have the cursor be in the box so I can navigate the list by using
the keyboard arrows. Any ideas?