ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macro Design Help (https://www.excelbanter.com/excel-programming/312510-macro-design-help.html)

Chuckles123[_16_]

Macro Design Help
 

In my workbook, I have a column of 50 prices for securities that i
created by the macro operating on a report from another system. In th
right adjacent column, the macro has copied each of these prices and i
awaiting confirmation of each price or for any or all of these price
to be changed by the user. Once all of the prices have bee
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,
Chuckles12

--
Chuckles12
-----------------------------------------------------------------------
Chuckles123's Profile: http://www.excelforum.com/member.php...fo&userid=1494
View this thread: http://www.excelforum.com/showthread.php?threadid=26641


Geof Wyght[_2_]

Macro Design Help
 
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

.



All times are GMT +1. The time now is 01:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com