For data entry using user forms the below is a good starter

http://www.contextures.com/xlUserForm01.html

If this post helps click Yes
---------------
Jacob Skaria


"Adele" wrote:

I would like to be able to make a worksheet for entering data in an invoice
and for relavant data to be copied to an excel list that can be used for
totals and recording payment. There was something in earlier versions of
Excel called Template wizard which I think could do this. Any suggestions.
I'm happy to have a go at VBA.