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



--
gauss1976
------------------------------------------------------------------------
gauss1976's Profile: http://www.excelforum.com/member.php...o&userid=36586
View this thread: http://www.excelforum.com/showthread...hreadid=565499

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


--
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
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
Importing EXCEL Spreadsheets into ACCESS -- Macro or VBA? Excel Worksheet Functions 0 July 12th 06 10:08 PM
Importing EXCEL Spreadsheets into ACCESS -- Macro or VBA? Excel Discussion (Misc queries) 0 July 12th 06 10:08 PM
UK Excel User Conference - July 19-21 Damon Longworth Excel Discussion (Misc queries) 0 May 1st 06 01:06 PM
UK Excel User Conference - July 19-21 Damon Longworth Excel Discussion (Misc queries) 0 March 29th 06 02:03 PM
Excel user defined functions. Matt Excel Worksheet Functions 4 March 15th 05 08:22 PM


All times are GMT +1. The time now is 06:16 PM.

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

About Us

"It's about Microsoft Excel"