Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Controls Toolbox | Excel Discussion (Misc queries) | |||
Control Toolbox Controls | Excel Programming | |||
Controls Toolbox control vs Form Toolbox control | Excel Programming | |||
Additional toolBox controls | Excel Programming | |||
Additional ToolBox Controls | Excel Programming |