Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Edit Cells while Macro is Paused at Message Box
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can a macro be paused to allow input, then continue? | Excel Worksheet Functions | |||
How to use macro to edit data in Excel cells | Excel Discussion (Misc queries) | |||
Macro to edit cells | Excel Programming | |||
Macro to edit cells | Excel Programming | |||
How do Macro to EDIT cells? | Excel Programming |