Current VB experience = approx 8 hours!!
I am creating a form that includes combo drop pdown boxes and simple text entry cells.
I need a short piece of VB code to asign to a button that can reset the combo boxes and simultaneously clear the unlocked cells - all with a single click.
I have got some code to reset the boxes using the linked cell value and I have seen some for clearing cell content... how do I combine them?.. All help appreciated
Replace 'MyUserForm' with the name of your form.
Please Login or Register to view this content.
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
You want a button that resets a form back to the state is was when first opened?
Example:
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks