Press Enter to run a Command Button - Driving me CRAZY

[Jimmy110]

Hi All,

Really need your help as I just cant get this to work.... Wanting to type a weight into cell C6, then I have a command button that copies the cell, transfers it to the bottom of a table in a different sheet and then deletes the value from the original cell....

Id love it if after typing the value in C6, all I had to do was press Enter and it would be like pressing the command button.

My code currently looks like this:

Private Sub CommandButton1_Click()
Dim Customername As String, Customerphone As String
Worksheets("sheet1").Select
Customername = Range("C6")
Worksheets("sheet2").Select
Worksheets("sheet2").Range("A1").Select
If Worksheets("sheet2").Range("A1").Offset(1, 0) <> "" Then
Worksheets("sheet2").Range("A1").End(xlDown).Select
End If
ActiveCell.Offset(1, 0).Select
ActiveCell.Value = Customername

Worksheets("sheet1").Select
Worksheets("Sheet1").Range("C6").ClearContents
Worksheets("sheet1").Range("C6").Select



End Sub

Any ideas?

 

[Fluff]

You have the code in the wrong place, it needs to go in the sheet module (where your command button code is), not a standard module.

 

[Jimmy110]

You have the code in the wrong place, it needs to go in the sheet module (where your command button code is), not a standard module.

Getting somewhere now! Thanks for that.... so its transferring the data...but a dialogue box is coming up with "1" in it...I press enter and then it changes to "2" and so on and so on...takes about 6 presses of enter to clear it...then it updates??? Whats your thoughts?

 

[Fluff]

Use the code I originally provided, which doesn't have the messages boxes.

 

[Jimmy110]

Use the code I originally provided, which doesn't have the messages boxes.

absolute superstar! works a treat! Thank you so much

 

[Fluff]

You're welcome & thanks for the feedback.

 

[Jimmy110]

You're welcome & thanks for the feedback.

Could I be cheeky and ask how I add a button on Sheet1 to delete the last row of the Table in "A"?

Logic being if someone makes a mistake entering a number, its easy to remove?

 

[Fluff]

As that's a completely different question, it needs a new thread. Thanks

 

[Jimmy110]

As that's a completely different question, it needs a new thread. Thanks

No Probs...I'll post one now. Thanks again