pause macro and show message box to click on it to continue

[Megatronixs]

Hi All,

I have some code that runs, but needs to be paused for a moment and then continue when a user clicks a button on message box that appears.
so it could be like below:

code runs
code comes to a pause point and shows message box
user clicks message box ok button when he finish
code continues

This will be part of a loop.

I was googeling with no luck. the only thing I found was the below that gives me an error when clicking on it (is like getting a second continue with code button)

Please Login or Register  to view this content.

any idea how to solve this?

Greetings.

[:) Sixthsense :)]

How you declared RetVal?

[jmac1947]

Howdy,
If I understand the issue, simply insert a msgbox "enter comment here" command in your loop and the execution will stop there, when the user clicks OK the next statement commences.

Or have I missed a point here???

[Megatronixs]

Hi,
I did not, I'm new to all of this and have no clue.
Let's say I have below loop. I would like it to pause before the next i. How should I declare it and put the message box in the correct place?

Please Login or Register  to view this content.

Greetings.

[Leon V (AW)]

a macro will pause when a message box is initiated anyway and continue when it is closed so just

Please Login or Register  to view this content.

inside the loop would work

[Megatronixs]

Hi Jmac1947,

That is the idea. I need to stop the loop so it will not run untill I say so.

Greetings.

[Megatronixs]

Hi Leon V,

The message box really stops it, when I click OK, I get the message box from excel: Code execution hs been interrupted > continute, end, debug, help.
This is kind of annoying that it brings me to the message box from excel and need to press again continue.
Any solution for not getting this one?

Greetings.

[Megatronixs]

Hi all,

I created my loop, but it misses something.
It should take the cell in column 10, and then when looping the next, the row below the previous one.

Please see my code and tell me where I go wrong, please ;-)

Please Login or Register  to view this content.

[Leon V (AW)]

that usualy turns up when you Ctrl+Break out of code not sure why it would turn up here. does your over arcing code have some ontime events in it?

[Megatronixs]

Hi,

there was no break in the code, everything runs fine. I wanted to pause the code on that point. It kind of works with the double pressing a button, but the loop does not work the way it should.
How can I tell the loop to go to the next row in column 10? (my expirience with loops is minimal).

Greetings.

[Megatronixs]

Hi,

I found some code for the loop, but get strange results as it does copy nothing from column 10. the value that it has to copy is: CJ 22945/2014 (so I don't know if it has to do with the way the text is)
can some one look at the below code and tell me where I go wrong?

Greetings.

Please Login or Register  to view this content.

[Megatronixs]

Hi,

It seems that the macro paste in random numbers, not the one from the current cell that has value of i in the loop.

[Megatronixs]

Hi all,

I guess I think I know what is wrong. I changed the loop code to below. Now it will pass "2" to the field in the website. It turns out that the value of i is 2. I need the value of the cell that the loop is in.
How can I change that part to make it work? please ;-)

Please Login or Register  to view this content.

[Solus Rankin]

Please Login or Register  to view this content.

[Leon V (AW)]

i is just a number.
are you trying to reference the cell at row i?

Please Login or Register  to view this content.

[Solus Rankin]

That's not the same code. Please post the code in its entirety.

[Megatronixs]

Hi all,
The solution from Solus did work out ;-) I just did not come up with the idea that I needed to pass the column value too ;-)
So Solus, THANKS A LOT ;-)

Now that the macro runs nice, I still have a little thing I would lilke to get rid of. The Internet explorer save as dialog box opens every time and I need to click 2 times to get rid of it (once for the chose folder and second time for saving it).
Is there a way to block this while the macro runs? it really slows things down :-(

All of you BIG THANKS ;-)

Greetings.

[Megatronixs]

Hi Solus,

If I now could get rid of the error when I come to the message box and it does not give the stupid error message, would be great + the evil IE save as dialog box

Here is the full code:

Please Login or Register  to view this content.

[Megatronixs]

Hi all,

I found the below link:
http://www.mrexcel.com/forum/excel-q...cations-3.html

And wanted to know if someone can help me in understanding which part I need to take from the code to stop the annoying save as dialog from windows. The file name that is downloading has unique name. All I need is that it uses the folder name that is in the cell to the left of the one the loop is current on. So if it happens to be that the loop is in row 25, then next to it is the folder name and that should be used to save the file in.

Greetings.