Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pausing a macro to select a cell
I would like to create a macro the copies data from a
list of named ranges and then do a past values into a worksheet for trends. That, by itself, is no problem. However, each month the paste values will be in a new column (one for each month). Is there a way to pause the macro so I can click the first cell in the receiving range differently each month? Thanks, Jim |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pausing a macro to select a cell
Jim,
You could do one of two things Application.InputBox with a type of 8, this will allow the user to select a cell and its address is returned from the input box you could use the date to work out which is the appropriate column. Post back with some specific details if you want more help -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Jim" wrote in message ... I would like to create a macro the copies data from a list of named ranges and then do a past values into a worksheet for trends. That, by itself, is no problem. However, each month the paste values will be in a new column (one for each month). Is there a way to pause the macro so I can click the first cell in the receiving range differently each month? Thanks, Jim |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pausing a macro to select a cell
try putting code in like this at the point where you need a break in the cod
Dim Start as Varian Start = Time Do While Timer < Start + 5 ' make the 5 larger if you need more tim DoEvents ' Yield to other processes Loo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA macro pausing | Excel Worksheet Functions | |||
pausing a macro to input cell contents | New Users to Excel | |||
Pausing a macro | Excel Discussion (Misc queries) | |||
Is there a way of pausing a macro | Excel Discussion (Misc queries) | |||
Pausing a VBA macro | Excel Programming |