Assign macro to enter

  • Thread starter Thread starter Diana
  • Start date Start date
D

Diana

Hi,

I want to run this macro when I press Enter:

"select the client to create the invoice moving with the arrows or
going directly with the mouse and when I press enter on that client
send the data to the invoice sheet"

Sub sendclient ()
client=Selection.value
SHEETS("invoices").select
range("A5").value=cliente
End Sub
"The client is in column 2"

Thank you
 
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column <> 2 Or Target.Count > 1 Then Exit Sub
sheets("invoice").Range("a5").Value = Target.Value
End Sub
 
Back
Top