tab movement

Hello All, In order to make the 'Up' and 'Down' arrow keys work properly, I am using some code like the following: First, the Worksheet Selection Change event: If Target.Row = 49 Or Target.Row = 58 Then Application.OnKey "{Up}", "NextUp_toRow31" GoTo UpArrowEnd End If and then, in a...

First time post so bear with me please :eeek: I have an excel worksheet 'Initial Form' that has many validation dropdowns from other worksheet using the Indirect method and Named Ranges: =INDIRECT(VLOOKUP($B$58,ItemCause2Lookup,2,0)&"List") It works fine but for some reason, only sometimes...

Windows("2016Saving.xlsx").Activate Sheets("R2").Select Sheets("R2").Move Before:=Workbooks( _ "Saving - Final.xlsm").Sheets(6) I am trying to move workbook's first tab to the other workbook. Is there any way to dynamic way to do this? tab name could be different so I need code...

I've always wondered and wish to figure out how to tab between sheets in a single workbook... Can it be done? i.e., I have 3 tabs and I want to use the keyboard to switch between them; not the mouse: very inefficient to move between the mouse and keyboard since all my work can be done by...

I'm working on a form. I've decided I really like the way the ActiveX combobox works. However, I would like to set it's back style to transparent and the showdropbuttonwhen to focus. When I do this, it's all good in the hood. However, when I make a selection (or go back to a blank in the...

I have always been able to use the tab key to go right to the next cell. However, at this new job, new computer, same Excel 2007, the tab key goes from column A to column V. Is there a way to change this? Thank you, I am desperate!

I do not know what I did, but now, when I press the Tab key on my keyboard while using Excel, the cursor moves ten cells over instead of the usual one cell. Please help.