I am hoping someone may be able to assist me with the creation of a User
Form button(s). I have managed to create a User Form that successfully
enters text into a worksheet however I am trying to add a command to my
“OK” button that not only enters text into but that also resets the
User Form in the event I wish to enter a new set of variables (i.e. I
have entered one client out of a list of 5) Alternatively, I tried to
create a “Clear Form” button that might be helpful in the event the
User wanted to remove the client without having to Cancel the Form
however thus far the command only clears One of approximately 25
fields. Any assistance on either command would be greatly appreciated.


Best,

Mike


---
Message posted from http://www.ExcelForum.com/

You just have to set each control to a blank or default value

Textbox1.Text = ""
Combobox1.ListIndex = -1
Checkbox1.Value = False

and so forth.

--
Regards,
Tom Ogilvy

"meflorence " wrote in message
...
I am hoping someone may be able to assist me with the creation of a User
Form button(s). I have managed to create a User Form that successfully
enters text into a worksheet however I am trying to add a command to my
"OK" button that not only enters text into but that also resets the
User Form in the event I wish to enter a new set of variables (i.e. I
have entered one client out of a list of 5) Alternatively, I tried to
create a "Clear Form" button that might be helpful in the event the
User wanted to remove the client without having to Cancel the Form
however thus far the command only clears One of approximately 25
fields. Any assistance on either command would be greatly appreciated.


Best,

Mike


---
Message posted from http://www.ExcelForum.com/

Easy enough! Thanks for the help Tom

--
Message posted from http://www.ExcelForum.com