How about not using a macro?

Data|form might be enough???

And if you want to try creating your own userform, Debra Dalgleish has some
getstarted instructions at:
http://contextures.com/xlUserForm01.html

Macro Help wrote:

I am new at Excel. I want to write a small macro, four or five columns where
I can go to column 1 and input data, then go to column 2 and input date,
etc., then when I get to the end of the fifth column have it return and go to
add more data in column 1. Any help will be appreciated from the experts
in Excel. Thanks.

--

Dave Peterson