Pause Macro, move to another cell, continue macro execution

[slotcardan]

This issue I am sure is probably discussed somewhere but I am a first time user. What I have is an inventory list. Column A is the vendor, and Column B is the part number. Both have been sorted A to Z. When the macro runs it processes the part number that is selected, returns to column B, goes down one cell to the next number to be acted upon. The problem is that number may be down 3 cells in column B so I need to move the cell pointer there, and then continue macro execution by enter. Is there any way to do this.

[Kaper]

so you probably have something like:

Please Login or Register  to view this content.

in your code now
try:

Please Login or Register  to view this content.

By the way - using seletion instead of coordinates (row and col) if often "good way to slow down macro execution - so try to avoid it.

[slotcardan]

Let me give you a better explanation. If I was using the old Lotus 123 macro language, I would insert this {?}. This pauses macro execution and you can use any other keyboard direction keys to move the cell pointer where ever you would like. Once you relocate and press enter the macro restarts where the pause occurred and continues until it finishes. I don't know if this is possible in Excel but would like to be able to do the same with VBA. Thanks for your response I greatly appreciate it.


Regards
Slotcardan

[Norie]

Why don't you use code to move down to the next part number instead of selecting it manually?

[slotcardan]

The macro actually selects the next cell down in column "B". However, the actual part number that I want may be down 3 cells lower or more, so I would like a way to pause the macro, move the cell pointer down 3 cells then press enter and continue the macro execution. Most of the time the next cell down in column "B" is the right part number that I want to work on, however there are those instances when this is just not so.


Thank You

Regards

Slotcardan

[Leith Ross]

Hello slotcardan,

Welcome to the Forum!

To expedite a solution, you should post a copy of your workbook. This will allow all code to be tested against the actual data and layout. If your workbook contains sensistive information, please redact it before posting.

How To Post Your Workbook

1. At the bottom right of the Reply window, Click the button Go Advanced
2. At the top of the Your Message Window, in the first row of icons, Click the Paperclip icon.
3. Click the Add Files button at the top right in the dialog box. This displays the File Manager dialog.
4. Click the Select Files button at the bottom middle of the dialog.
5. In the new window Find the file you want to upload, select it, and Click Open.
6. You will now be back in the File Manager dialog. Click the bottom Middle button Upload File.
7. Wait until the file has completely uploaded before you exit the File Manager dialog.