Run-Time error 1004 Method 'OnTime' of object '_Application' failed
I am running the following code which runs until the last line of the StopBlink sub, when it returns the error
"Run-Time error 1004 Method 'OnTime' of object '_Application' failed". Could someone please explain the issue for me.
Please Login or Register to view this content.
Last edited by JBeaucaire; 04-22-2015 at 09:38 PM. Reason: Added missing CODE tags. Please read and follow the Forum Rules, link above in the menu bar. Thanks.
Hi PBM,
You can only run the StopBlink macro if the StartBlink macro is already running (i.e. the text in cell C2 of Sheet1 is flashing). If the StartBlink macro isn't running and you try and execute the StopBlink macro, you'll get the above error message.
Please make sure to wrap your code with the appropriate tags.
Regards,
Robert
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
Hi Robert, thanks for your reply. I am not sure what you mean "Please make sure to wrap your code with the appropriate tags" ?
I was of the understanding that the following Macro in the "ThisWorkbook" open module would run the StartBlink.
...PeterPlease Login or Register to view this content.
Last edited by JBeaucaire; 04-22-2015 at 09:38 PM. Reason: Added missing CODE tags.
what's the code for startblink?
nvm-I can't read!
Last edited by JosephP; 08-28-2013 at 03:30 AM.
Josie
if at first you don't succeed try doing it the way your wife told you to
Refer Rule 3 here and have a look at how I've wrapped my code below.I am not sure what you mean "Please make sure to wrap your code with the appropriate tags" ?
Yes, as long as StartBlink is running. If the StartBlink code is stopped at any point while the workbook it is open, the error message will appear when the workbook is attempted to be closed.I was of the understanding that the following Macro in the "ThisWorkbook" open module would run the StartBlink.
As we're not concerned about the error, you can simply turn off the message from appearing (importantly not fix it) via the following:
HTHPlease Login or Register to view this content.
Robert
Thank you agaion Robert,
you have managed to turn off the error message which is great. I now have one other issue I hope you can help with. My C2 text does not blink however each time I save & close the workbook upon reopening it my C2 text is either RED or White so the code ispartially working.
Regards..Peter
Not sure as it works for me
If the code isn't firing up when the workbook is opened that would actually explain the original error message!! Are macros always enabled when workbooks are opened? The code is set to work on cell C2 of Sheet1 - that's where you're looking isn't it?
Also, the following event macros that you posted in #3 above...
...needs to be attached to the ThisWorkbook object not simply in a standard module.Please Login or Register to view this content.
If the issue continues attach the workbook (devoid of any sensitive data if need be) and I'll have a look.
Robert
Last edited by Trebor76; 08-27-2013 at 09:03 PM.
Hi Robert,
Yes, Macros are enabled and I am referring & looking at cell C2 of Sheet1.
Also, the event macro I posted in #3 is attached to the ThisWorkbook object.
Unfortunately I cannot attach the workbook, when uploading the file it presents an error message and wont allow attaching.
So I'm stumped now as I guess you cannot help further without a copy of my file. Am I right, or is there something else you can think of?
Peter
PS. Just a thought, the text in cell C2 is overflowing to adjacent cells.
Could this be the cause?
Without seeing the patient (i.e. workbook) it's very hard to diagnose the problem.
That said, have a look at the attached that's working as expected and try and replicate it on your side.
Regards,
Robert
Hello again Robert,
Firstly I must thank you again for taking the time to help me out.
I looked at the file you created and the code is exactly as mine and in the same locations, the only difference was your first line - Options Explicit
which I added to my Macros.
Unfortunately the result still the same, No Blink.
I attempted to Upload my file again but still receive the same error below, maybe you can shed some light on this issue so I can forward my file as suggested earlier.
Error Message: 500[IOErrorEvent type="ioError" bubbles=false cancellable=false eventPhase=2 text=ERROR#2038]
Regards,
Peter
No idea why you can't upload your file (perhaps size?) One of the administrators should be able to help.
Did my workbook work?
Robert
Yes Robert, your workbook did function in the correct manner so now I am totally stumped why mine doesn't with exactly the same code.
I will try to find a solution for the file upload issue and if/when I do, will forward my workbook. This may take a while!
Cheers & thanks again for your time.
Peter
Hey Peter,
Have you seen my PM to you?
Robert
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks