Excel has data|form built in. Maybe it'll be sufficient.

If not, you could build your own userform.

Debra Dalgleish has some notes:
http://www.contextures.com/xlUserForm01.html

TUNGANA KURMA RAJU wrote:

I would like to add data to last row of each sheet daily,by using a data
entry user form.The necessary fields are 1.sheet name,2.date,3,points
earned.fields 2 and 3 are common(column headings)to all sheets.Is this
possible?

--

Dave Peterson