Help with a counter

I am trying to complete a macro and user form combination. The purpose of the macro is the entry of numbers in to a spread sheet from the userform control buttons. Have got the data to enter on to the sheet from the user form and then select the next cell for entry. There are 6 entrys requred before moving to the next row (following a prompt box to move to the next row) I am trying to encorporate a button to allow an entry to be re entered because of an error the macro will move back when the re-enter control button is pressed but the count is not altered and thus I don't get 6 entries.

The code I am using for the main macro is:-

Please Login or Register  to view this content.

The code for the controlbutton (re-enter button) is:

Please Login or Register  to view this content.

Can anyone help? (if you understand what I mean)

read the Forum Rules & wrap your code with Code Tags.

Your code seems a complicated way of doing this, take a look at the DatabaseForm example here

http://www.excel-it.com/vba_examples.htm