Start VBA after data entry

[Hans810]

Dear All,

In an Excel worksheet I have one data entry field (Cell) which has to be filled with data by the user.
After entering the data, I would like to start a VBA macro which is triggered by the ENTER key.
How do I do that???

Thanks in advance!
Hans

 

[VoG]

Try this: right click the sheet tab, select View Code and paste in

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address(False, False) = "A1" And Target.Value <> "" Then Call MyMacro
End Sub

Change A1 and MyMacro to suit.

 

[Hans810]

HI VoG,

Thanks for the quick response.
I tried the code but it returns an error!

BR, Hans

 

[VoG]

Can you post your actual code and what is the error message?

 

[VoG]

In response to your PM try

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address(False, False) = "C3" And Target.Value <> "" Then
    Application.EnableEvents = False
    Call start
    Application.EnableEvents = True
End If
End Sub