Writing macro results to user defined areas within excel
I am writing macros that manipulate data within excel. Is it possible to a write a macro that produces a result; say a graph or a set of values and then get the macro to ask the user where to place the calculated result/results/graph within excel? Gauss1976 :confused: -- gauss1976 ------------------------------------------------------------------------ gauss1976's Profile: http://www.excelforum.com/member.php...o&userid=36586 View this thread: http://www.excelforum.com/showthread...hreadid=565499 |
Writing macro results to user defined areas within excel
You can get a range from the user by something like:
dim DestCell as range set destcell = nothing on error resume next set destcell = Application.inputbox(Prompt:="Please select a cell", _ type:=8).cells(1,1) on error goto 0 if destcell is nothing then 'user hit cancel, what should happen? else 'keep going?? end if Alternatively, you could just tell the user that the output will be placed in the activecell--so they should select that before they start the macro. dim destcell as range set destcell = activecell ..... gauss1976 wrote: I am writing macros that manipulate data within excel. Is it possible to a write a macro that produces a result; say a graph or a set of values and then get the macro to ask the user where to place the calculated result/results/graph within excel? Gauss1976 :confused: -- gauss1976 ------------------------------------------------------------------------ gauss1976's Profile: http://www.excelforum.com/member.php...o&userid=36586 View this thread: http://www.excelforum.com/showthread...hreadid=565499 -- Dave Peterson |
All times are GMT +1. The time now is 08:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com