Input in makro

Use a command in your macro as shown below.

Dim MyInput As Variant
MyInput = InputBox("Enter my input", "Default value", Title of InputBox"
If Len(MyInput) = 0 then Exit Sub

The macro continues running when the user presses ENTER. The last line above terminates execution however, if the user entered nothing. To do so in the above case he would have to delete the default value. But you can omit the default value argument from the InputBox syntax and present a blank field to the user in that way.