Is there any "trick" out there so when a user presses the command button that allows them to cancel instead of save changes on a user form the original values are restored, other than saving all the textboxes, comboboxes, listboxes, check boxes, ..., to variables/an array and then restoring them? I'm afraid I have two rather involved userforms that will take a bit of work to restore original values-
Thank-you for thinking about it!
The simplest way is not to sve any changes until you are ready.
Then use a save button to save all the changes at the same time.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Hi brucemc77
How are all the textboxes, comboboxes, listboxes, check boxes being populated with the original values...UserForm Initialize Event?
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
Hi brucemc77,
To allow us to best assist you in this case is to, attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Because browsers behave differently, many of our members cannot see uploaded images. Do not upload a picture of your file as this will only delay getting solutions.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Controls are being populated whenever a combobox that serves as an index of all of the records (rows) on a worksheet changes value and are brought in by reference to the worksheet in one instance, by loading all of the values dumped into the combobox list in another. User has the option to hit a command button that enables editing. Yes, I could simply reload the userform, but compared to reinstating original values from an array, reloading looks pretty poor.
Now that I wrote this it occurs to me (Thanks jaslake!) that I should be able to keep the form up and just run the portion of code that loaded all the values in from a purpose built module...
If that works, and I see no reason it shouldn't, dang do I feel embarrassed...
Hi brucemc77
When I was in the "Business" many years ago designing systems, we, the "Users" and the IT guy(s) (never had more than 2) would sit around the conference room table with a White Board at the end. The IT guy(s) would flow chart the "Users" ideas. It was a painful but productive process.
Long story short...someone would make a comment...suddenly someone (a "User" or an IT guy) would have an "AH HA" moment...that's what you've had...Let us know how it goes...good hunting.I should be able to keep the form up and just run the portion of code that loaded all the values in from a purpose built module...
Just glad all you folks are understanding; especially when my "AH HA" moment is more like a "Oh no, I didn't just do that!" moment!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks