Part one is not practical with a Message Box.

In part two, you could probably write some code to use an input box and
update the status of Items that you find needing it during your edit. It
would not be automatic. You would have to have a separate macro to run the
updates but you could Identify those needing updating with the edits and then
start the update macro to complete the task.

"Magoo" wrote:

Is there a way to edit cells while macro is paused at message box? I
have a spreadsheet that uses autofilters. Currently I am able to use a
macro to cycle through one of the Autofilters to print unique data. I
would like to now Using VBA cycle through one autofilter and come to a
message box. Once at the message box I would like it to stay active
while I edit a few of the filtered cells. Then I would like to hit the
Messagebox's OK button to go to the next autofiltered result and do
the same thing.

If that can't be done, Can the following be done instead?

Sorry that the subject is vague but, I was wondering if the following
is possible. I have a spreadsheet that I maintain that holds a years
worth of data. It is very similar to the following:

Name QTY Item Status
Name, one 1 Item one
Name, two 2 Item one
Name, three 1 Item two
Name, four 2 Item one


What I would like to be able to do is to count the items that have
come in and place that figure into an input box. And then mark that
particular amount as being received.


So let's say that 1 item one has come in. I would like to put
received
in the corresponding Status cell. It would get tricky if only 3 Item
ones came in. I would like to based on a total in the qty column
place
received in the corresponding cells as shown below:


Name QTY Item Status
Name, one 1 Item one Received
Name, two 2 Item one Recieved
Name, three 1 Item two
Name, four 2 Item one


Is there a way to do this via VBA? One more note is that I am using
autofilters.


If there is a way to do this I would greatly appreciate the
assistance.