If the user clicks on the button more than once, a msg box woould appear stating "Runtime Error '1004': Method Range of Object '_Global' Failed"/ However, nothing would happen to the fields or data. Is there a way to add a line of code such that when user decides or accidentally presses the button more than once, no error msg would appear and noting will happen to the data?
Please Login or Register to view this content.
Hello jlyh11,
Welcome to the Forum!
To better understand your problem, please post a copy of the workbook for review. It will save a lot time if you do.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hi Leth,
I know the problem.
What I do is define Public variable isBusy as boolean
The routine wher you press the button should be some like this:
Hope this gives you an ideaPlease Login or Register to view this content.
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
Hello Keebellah,
I am waiting for the OP to respond before proposing any solutions. Assumptions made on a code fragment can waste a lot of time. Perhaps you have a lot of time but do not assume the same for the OP.
Hi Leith, I cant post a copy of the workbook as the information of the company is private and confidential. Let me try to explain the issue again.
When the user presses a macro button more than once, an error will pop up saying: Error 1004, no cells were found. I do not want to see this error box even if no cells were found. Thus, what I need is that no error box will appear no matter how many times the user presses the macro button.
Hello Keebellah,
I tried to put this in together with the exisiting code but it didnt work. The error box still came out. Could you see if the order is correct?
Please Login or Register to view this content.
Last edited by jlyh11; 10-22-2015 at 02:03 AM.
Without seeing your workbook the max I can suggest you to use one line of code in the beginning On Error Resume Next and see if the code doesn't produce any undesired output if it bypasses that error and gets executed again.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Or after looking at your code, it seems that you might get an error because of the following line if no blank cell is found
So to avoid that error you may replace the following lines of codePlease Login or Register to view this content.
With thisPlease Login or Register to view this content.
See if that resolves your issue.Please Login or Register to view this content.
Could you explain your "Perhaps you have a lot of time but ..."Originally Posted by Leith Ross
The idea is not an assumption, it's reading what the OP says.
A button can be pressed many times and can trigger error. It was just an idea.
And also yes: I DO HAVE A LOT OF TIME that's the advantage of being and old and retired person
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks