Stop a macro to allow editing a cell , then co

  • Just a thought you could pull the information from that cell into the macro and in a input box and allow him to edit it there. That would probably get you up and running.


    But the answer to the question as posed has elluded me as well.

  • You could use the INPUTBOX function to get the new value from the user,(set equal to a variable) and then have your VBA code paste it into the cell.


    EDIT: Sorry, Epidemic. You're not chopped liver, just too fast ... and I'm just too slow and unobservant. :wink2:

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!