Good day all,
I have a userform with textboxes that if blank will not let the user proceed, the problem I have is if the user requires to just exit the userform my textbox conditions prevent them, is there a code I can attach to my "Exit" commandButton to override the textbox conditions?
Thank you all & have a great day - Marco
Hi matrixpom,
That would depend on the how the Code is written, and without seeing the actual Code, we would not really be able to assist you.
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] .
No worries Winon, please find code below
Textbox code:
My Exit cmd button code is:
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by matrixpom; 10-25-2012 at 08:49 PM.
Thank you,
Now, for the Exit Button try:
Hope that helps.Please Login or Register to view this content.
Hi Winon,
Strange...it looks like your code should work but I still get my message "ABN Required" I've taken out "cancel=True" from my textbox code & now exit works but only on the second attempt?
Hi matrixpom,
Could you upload a sample WorkBook with all the relevant Code, for us to have a look at.?
Hi Winon,
Please find attached & thank you for your time - Marco
Hi matrixpom,
I did not want to change too much of the user input checks on the UserForm, but see if you can make do with the attached Workbook as it is now.
Yes...it does work, i need to get this workbook out Nationally ASAP, so this will buy me loads of time, than you Winon, you have a great weekend! Marco
You are welcome.
Glad I could help a little.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks