Hi I am really not getting why am I getting error after Macro runs successfully for 90 to 91 times.
I continuously Enters value in the text box of form and it successfully printing each time I enter value for 90 successive values.
and then
my code get stuck at a line of code
Please Login or Register to view this content.
Is there any buffer or VBA Memory issue linked with ?
Here I am attaching my macro, pls test and advise me solution.
Regards
Maybe:
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
You Can disable the line of code to avoid real time printing... and test entering the values in form and check its stops after around 85 to 90 iterations of values entered.
Please Login or Register to view this content.
@xladept . I tried using below but same problem still persists.
Please Login or Register to view this content.
I just ran that portion 100 times
see my error after 95 times
I just ran that portion 1000 times
I've submitted this issue to the Forum at large - I suspect it's something to do with the 2016 version
Is there any way to find out whether it is related to Vba Memory by any chance as code stops after 95 values entered and form is not getting unloaded after that..
Last edited by naveenmarapaka; 03-04-2018 at 02:14 PM.
How about this one.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
@Bakerman2 ... WOW... that worked as form is not unloaded but I noticed a problem after scanning or entering a value, Form is not active again after print out comes , we have to click the form with mouse to make it active.
Last edited by naveenmarapaka; 03-05-2018 at 02:41 AM.
Try it this way then.
@bakerman2, Please refer attached video, for checking code faster I just disabled printing line and just pressing enter as if a value is entered. pls check counter increasing every time. finally It gave error at count 93..
I figured out the issue and I have used your idea below code in my original module1 and only added 1 extra line of code
to activate back my form after printing done and this trick did my job easy and its working absolutely fantastic without any bug.Please Login or Register to view this content.
Thanks a million dear you have made my day.
Please Login or Register to view this content.
Last edited by naveenmarapaka; 03-05-2018 at 02:43 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks