VBA code to prompt user to select a cell

[louisepr]

Hi Am I able to use VBA to prompt a user to select a cell in a worksheet? This will then govern the row for the rest of the actions within the macro

 

[My Aswer Is This]

Try something like this:

Sub My_Script()
'Modified 12/3/2020  2:23:29 AM  EST
Dim c As Long
c = Application.InputBox("Select Cell", Default:=Selection.Address, Type:=8).Row
Cells(c, 1).Value = "Me"
End Sub