UserForm - Two Button - Start and Pause button

[balaji761995]

Hi,

In my project i have user form with three buttons start, pause and resume, start function will perform operation for around 10K data using for loop, and I want 2nd button to pause the function in between 100th or any position and 3rd button resume the same function from where it left. Please help on this I am trying to pause function its not working for me.

after clicking start button other button are not able to click, after 10K data entry is completed only I can able to click.

Thanks

[6StringJazzer]

Please show all the code in your UserForm module. Use code tags. It would be even better to just attach your Excel file, see yellow banner at the top of the page.

There are two ways to add code tags. One is to select the code part of the text so it is highlighted, then press the "#" button in the edit controls. The other is to simply type in the tags:

[code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code]


Why use code tags? Code tags:

1. Are required by rules (see rule #2)
2. Preserve spacing used to show code structure (otherwise leading spaces and repeated spaces are removed)
3. Add scroll bars to navigate code with long lines or a lot of lines

[balaji761995]

please find below the code, I want to pause the bulkData function when click on commandButton2

Please Login or Register  to view this content.

[torachan]

no attachment - paperclip does not work.
see big yellow banner - how to upload workbook.

[Corbett]

I have restructured the logic a bit. You just need one button which acts as the start and pause / resume. The code for your userform will be as follows:
It is all contained in the attached workbook.

Please Login or Register  to view this content.

[balaji761995]

thank you so much for your help

[6StringJazzer]

If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

If a member helped you solve your problem, consider adding to their reputation by clicking on the star icon addreputationiconsmall.jpg below their name.