I have an Excel sheet that shows a column with names. In my Macro I select (via an input box) the name of the person who I want to see. When I enter the name all the data associated with that person and within that row will be displayed. My code works fine, except, when "Cancel" is hit. I need code that will stop the macro when "Cancel" is entered, as of now the macro continues, I need it to stop. Any suggestions? Here is my code:
Please Login or Register to view this content.
Put this immediately after using the input box to set the ans1 variable.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."
Thanks Solus, I can't believe how simple that was. I was thinking too much!
No problem. Glad I could help.
If you are happy with the solution please mark the thread as [SOLVED] using the thread tools at the top.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks