JK:
Where or how is the information entered on your form? Do you have
seperate text boxes for NO & ITEM or are they together? Does the user
click a command button to enter the data to your sheet? What is the
name of the sheet? Are you using named ranges? If you can answer
these questions then maybe I can help...Mark