Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Where are the functions that used to be the macro design toolbar? | Excel Discussion (Misc queries) | |||
how do i design a macro | Excel Discussion (Misc queries) | |||
Office2007 - Can I design a button for toolbar macro? | Excel Discussion (Misc queries) | |||
Excel Workbook automatically (by design) runs a macro | Excel Programming | |||
Excel Workbook automatically (by design) runs a macro | Excel Programming |