Creating a tab order on vba embedded toolbox controls

[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?

[K Dales]

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
>
>