Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 38
Default 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

.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Where are the functions that used to be the macro design toolbar? Special K Excel Discussion (Misc queries) 0 October 29th 09 02:16 AM
how do i design a macro Santhosh Excel Discussion (Misc queries) 3 May 27th 08 04:39 PM
Office2007 - Can I design a button for toolbar macro? OldJohn Excel Discussion (Misc queries) 1 May 19th 08 01:45 PM
Excel Workbook automatically (by design) runs a macro Paul Excel Programming 0 August 5th 04 10:49 PM
Excel Workbook automatically (by design) runs a macro Chip Pearson Excel Programming 0 August 5th 04 08:24 PM


All times are GMT +1. The time now is 12:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"