|You would use the InputBox method. This is not something you can record, you have to either write the code from scratch or modify code created by the recorder.|
Here is a simple example. Paste the code into a VBA editor window, place your cursor on the word InputBox and hit F1. This will open the help window for the InputBox method and explain how it works.
'Get Row Number
MyRow = Application.InputBox("What Row Number Do You Want to Clear?", "My Row Clearer", Type:=1)
'Close Box If User Cancels
If MyRow = False Then Exit Sub
'Clear the Row