Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have set the tab order for my worksheet from some code I found in another post. It works perfectly for going forward, but if you want to go backwards there is an error. Can someone please look at my code and tell me where my problem lies
Private Sub ComboBox6_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer Dim bBackwards As Boolea Select Case KeyCod ''' These are the only keys we care about Case vbKeyTab, vbKeyReturn, vbKeyDown, vbKeyU Application.ScreenUpdating = Fals ''' Determine if we need to move backwards bBackwards = CBool(Shift And 1) Or (KeyCode = vbKeyUp ''' Activate the appropriate control based on key(s) pressed If bBackwards Then Range("L10").Activate Els ComboBox1.Activat Application.ScreenUpdating = Tru End Selec End Su |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Code for variable sort order | Excel Discussion (Misc queries) | |||
Code for counting the order cells are filled | Excel Discussion (Misc queries) | |||
VBA code for Extracting Data but order of columns changes all the | Excel Discussion (Misc queries) | |||
require macro or code for purchase order to do the following: | Excel Worksheet Functions | |||
setting tab order by code | Excel Programming |