Resetting cells

S

Sony

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?
 
G

Guest

Thank you Nigel.
-----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






----== 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 =---
.
Click to expand...
 
S

Sony

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
 
Top