View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Magoo Magoo is offline
external usenet poster
 
Posts: 21
Default Edit Cells while Macro is Paused at Message Box

On Feb 25, 5:20*pm, JLGWhiz wrote:
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.



Could you provide an example?