If changing all of the values and changing all of them in
sequence, say from 1 to 50, is not necessary then you
won't know when the user is finished. I would provide a
button that kicks off the next procedure.
Geof.
-----Original Message-----

In my workbook, I have a column of 50 prices for
securities that is
created by the macro operating on a report from another
system. In the
right adjacent column, the macro has copied each of these
prices and is
awaiting confirmation of each price or for any or all of
these prices
to be changed by the user. Once all of the prices have
been
confirmed/changed, the macro is then ready for subsequent
processing.
What is the best way to accomplish this in the macro?

Thanks for a response,
Chuckles123


--
Chuckles123
----------------------------------------------------------
--------------
Chuckles123's Profile:
http://www.excelforum.com/member.php?
action=getinfo&userid=14948
View this thread:
http://www.excelforum.com/showthread...hreadid=266414

.