Excel – How to run an event on Enter key in Excel VBA

microsoft excelvba

I'd like to have Excel change to a predefined data in any cell in column A whenever the user hits the Enter key (instead of the default go to next cell behavior). How can I achieve this in VBA?

Best Answer

Try do it in Workbook_open event

Private Sub Workbook_Open()
    Application.OnKey "{ENTER}", "MyEnterEvent"
End Sub

Sub MyEnterEvent

    ' codes here

End Sub

To end Macro

Application.OnKey "{ENTER}"

Related Solutions

Excel – Basics of how to make a VBA procedure run in excel when a Cell is changed

Right click on the sheet tab and choose View Code. Put code like this in the sheet's module

Private Sub Worksheet_Change(ByVal Target As Range)

    If Target.Address = "$A$1" Then 'only run if the correct cell is changed
        MySub 'this is the name of your vba procedure
    End If

End Sub

This sub will run whenever a cell on that sheet is changed. If the cell that's changed is A1 (change to suit your data), then a procedure in a standard module named MySub (change to suit) will be run.

I'm not sure why you have to use VBA though. It seems like you could write SQL to pull from as many tables as you want and include a parameter.

Best Answer

Related Solutions

Excel – Basics of how to make a VBA procedure run in excel when a Cell is changed

Related Question