CC, you could use something like this and assign it to a button, or you may
want to save the form as a template, that way when you open it you will have
a blank form to start with each time

Sub Clear_Column_A()
'Clears column A
Columns("A:A").ClearContents
End Sub
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"CC" <CC@discussions.microsoft.com> wrote in message
news:6279C797-4236-45BB-BD75-C6822210CC62@microsoft.com...
>I have created an electronic order form and would like to make it reusable.
> Is it possible to install a Reset or a Clear button, so the 'quantity'
> columns will go back to 0?