I'm not a VBA pro, but I'm sure this is a pretty simple question.
I am building a simple wizard tool.
How can I take the code below and do two things:
1. I want to ask, how many changes will be made?, The user can then type 7, and the code will run 7 times, but the values will be one row lower so they don't override data.
2. If the user decides to cancel, I want the whole thing to cancel, so you don't have to cancel each message box.
Please Login or Register to view this content.
Last edited by Rick-O-Shay; 07-02-2020 at 12:26 AM.
What happen if the user cancel at the 3rd (of 7 times)? Keep the values of 1st and 2nd or cancel them?
Hi,
Keep what they have, but stop from there.
Try this
Please Login or Register to view this content.
❖ Please mark your thread is SOLVED if there has been offered a solution that works fine for you.
❖ If you like solutions provided by anyone, feel free to add reputation by clicking on ✶ Add Reputation bottom left of their posts.
Awesome man, thanks so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks