tab movement

  1. D

    Left arrow key will not behave

    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...
  2. M

    Drop Down Validation cell redirecting to another Tab

    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...
  3. J

    how to copy workbook's first tab to another workbook?

    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...
  4. C

    How do I tab WITHIN a workbook?

    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...
  5. F

    combobox transparency and tab around

    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...
  6. V

    Tab Key usage

    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!
  7. W

    Tab movement

    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.

Some videos you may like

This Week's Hot Topics

  • Check VBA code to locate value in cell
    Hello this is the current code I have [CODE=vba] Private Sub TextBox1_AfterUpdate() Dim m As String Dim rx As String rx = Trim(TextBox1.Text)...
  • Reverse Numbers Formula
    Hello Everyone! My computer is Asus My Operating system is Windows 10. Can someone please help me with a formula that I can drag down (or up) to...
  • Count If Issue
    Hi all, I'm trying to create an spreadsheet which counts certain words in a cell only once and gives me a total. I can do this but some of the...
  • VBA Check for multiple cell values and copy the cell in column A
    Hello! So I have this code that checks for the values in column "L" in this case it's 25. But I want to change this code so that it actually...
  • Sending mails to specific recipients based on a cells value
    Good morning, I am trying to get excel to send out an email to different sales reps. So if row X is an error code of "999" then excel needs to...
  • Matching Number in Textbox
    Hello Excel Users, I come with a request. Hope all are doing fine. So I have 1 textbox to type in numbers etc. 12345 (it will always be 5...