Creating a tab order on vba embedded toolbox controls
 

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?


--
afiack
------------------------------------------------------------------------
afiack's Profile: http://www.excelforum.com/member.php...o&userid=12915
View this thread: http://www.excelforum.com/showthread...hreadid=525821

Creating a tab order on vba embedded toolbox controls
 

Instead of .Select try .Activate
--
- K Dales


"afiack" wrote:


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?


--
afiack
------------------------------------------------------------------------
afiack's Profile: http://www.excelforum.com/member.php...o&userid=12915
View this thread: http://www.excelforum.com/showthread...hreadid=525821