Run Macro if Enter is Pressed & in a certain row

[johneh]

We use hand scanners while doing phyiscal inventory and if scans into a Excel workbook.

I am try to figure out how to create a macro that will run only...
If in Column C and enter is pressed

Any ideas?
Thanks

 

[Domski]

Is the scanner entering data into column C and you are pressing Enter to confirm this or are you pressing enter to move down a cell? On ask as I've never used one myself so not sure exactly how they work entering data into a worksheet.

Dom

 

[jim may]

This seemed to work for me...
In your Sheet Code Module paste in

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Intersect(Target, Range("C:C")) Is Nothing Then Exit Sub
MsgBox "you are in Column C"  'REPLACE THIS WITH DESIRED CODE
End Sub

 

[davesweep]

You could also use onkey

Sub StartOnKey()
'Run this sub to make the ENTER-key run "SubMyCode"
Application.OnKey "{ENTER}", "SubMyCode"
End Sub

Sub SubMyCode()
If ActiveCell.Column = 3 Then
'your code here
End If
End Sub


Sub StopOnKey()
'Run this sub to release the onkey event
Application.OnKey "{ENTER}"
End Sub

If you mean to use the CR key, replace {ENTER} with ~