Excel TAB button

[Nilesh_kamble]

Dear All,

I want to when I click on TAB button then this will go in down (like Enter button)

Please let me know if any one know the same.

Regards,

Nilesh K.

 

[Domenic]

The OnKey method of the Application object can be used to change the behaviour of the Tab key. So, for example, to change the behaviour of the Tab key for a specific workbook, try the following...

In a regular module, let's say it's called "Module1":

Private Sub TabDown()

    ActiveCell.Offset(1, 0).Select
    
End Sub

In the code module for "ThisWorkbook":

Private Sub Workbook_Activate()
    Application.OnKey "{TAB}", "Module1.TabDown"
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
    Application.OnKey "{TAB}"
End Sub

Private Sub Workbook_Deactivate()
    Application.OnKey "{TAB}"
End Sub

Private Sub Workbook_Open()
    Application.OnKey "{TAB}", "Module1.TabDown"
End Sub

Save, close, and re-open the workbook.

Hope this helps!