Hi,
I am using a Module which directs user the sheet that is written by user. But whenever user writes the sheet name wrong it says "Run time error" and whenever user hits cancel it gives the same error. I want that: Whenever user hits cancel I just want that box to be closed but whenever user writes wrong sheet name I want to use On Error GoTo errmsg code to warn them about wrong sheet name and direct them again to write the sheet name correct.
I'd appreciate if you can help.
Thank you
Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.
Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.
In addition say what keys you have pressed and values you enter when you get the run time error.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks