LinkBack URL
About LinkBacks
Hello,
I am using userform1 to retrieve data from sheet.
If the sheet name I selected does not exist, it shows error and close.
So is there any MsgBox that shows " The month you selected does not exist"?
Please help.
Charles
Show MsgBox if mentioned Sheet does not exist
Hello,
I am using userform1 to retrieve data from sheet.
If the sheet name I selected does not exist, it shows error and close.
So is there any MsgBox that shows " The month you selected does not exist"?
Please help.
Charles
Last edited by ebin charles; 06-20-2011 at 04:41 PM.
Better then suggesting that the user did 'something wrong', you prevent the user doing so presenting him/her only options that do exist.
eg. all sheets:
Please Login or Register to view this content.
Mayhap:Please Login or Register to view this content.
If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.
---Keep on Coding in the Free World---
Thank youOriginally Posted by snb
Better then suggesting that the user did 'something wrong', you prevent the user doing so presenting him/her only options that do exist.
eg. all sheets:
Please Login or Register to view this content.
I take this. This suite for me.
Than you
Never mind me, snb included the form which I did not. Nice one snb
Thank you.Mayhap:Please Login or Register to view this content.
This looks ok, it use to navigate from sheet to sheet which consist of
10 or 15 sheets.
Thank you,.
charles
Please do not Quote.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks