Nigel, Will this work for multiple cells? For example, I
wrote the code to advance to next row for next entry. So
would a modified version of this work in that fashion?
Thx again
-----Original Message-----
Insert an event in your user form for the reset button
(I have named it
Reset)
Yuo need to set the userform controls to an appropriate
value eg Textbox
with the reset value, checkboxes, options buttons to
true or false, whatever
you deem as the reset state.

Private Sub Reset_Click()
TextBox1.Value = ""
CheckBox1.Value = False
OptionButton1.Value = False
End Sub

Cheers
Nigel

"Sony" wrote in
message
...
I want to be able to clear all the fields that are
being
populated by a userform with a command button. Can
this
be done?




----== Posted via Newsfeed.Com - Unlimited-Uncensored-
Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the
World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total
Privacy via Encryption =---
.