changing cells from function

  • Thread starter Thread starter Alex Colomb
  • Start date Start date
A

Alex Colomb

I'd like to be able to call a funciton from a cell that
populates other cells within the same sheet. I know this
isn't possible as user defined functions can't return
values to cells other than the one its used it, but I've
seen it done in certain addins (bloomber's BLPH function).
Do these addins do something special that normal VBA users
don't have access to?

I'm using VBA to make a soap call that returns an array of
data. I'd like then populate certain cells within the
worksheet with that data. Any ideas on how to do this
without using a macro? Thanks.
 
(Other posters: See the Willow Solutions web page that discusses retrieving
real-time and historical data from Reuters or Bloomberg subscribers at
http://www.willowsolutions.com/tips/downloads/tip_2001_01.doc.)

I believe that the BLPH function that you are referring to simply returns an
array of data, which you then enter into multiple cells on your worksheet
using standard Excel array formula notation. Pull up Excel Help and type
"array formulas" in the Answer Wizard to see more about entering and using
array formulas.
 
(Other posters: See the Willow Solutions web page that discusses retrieving
real-time and historical data from Reuters or Bloomberg subscribers at
http://www.willowsolutions.com/tips/downloads/tip_2001_01.doc.)

I believe that the BLPH function that you are referring to simply returns an
array of data, which you then enter into multiple cells on your worksheet
using standard Excel array formula notation. Pull up Excel Help and type
"array formulas" in the Answer Wizard to see more about entering and using
array formulas.

(2nd post. First one was deleted by the server for some reason.)
 
(Other posters: See the Willow Solutions web page that discusses retrieving
real-time and historical data from Reuters or Bloomberg subscribers at
http://www.willowsolutions.com/tips/downloads/tip_2001_01.doc.)

I believe that the BLPH function that you are referring to simply returns an
array of data, which you then enter into multiple cells on your worksheet
using standard Excel array formula notation. Pull up Excel Help and type
"array formulas" in the Answer Wizard to see more about entering and using
array formulas.

(2nd post. 1st one lost by the server.)
 
(Other posters: See the Willow Solutions web page that discusses retrieving
real-time and historical data from Reuters or Bloomberg subscribers at
http://www.willowsolutions.com/tips/downloads/tip_2001_01.doc.)

I believe that the BLPH function that you are referring to simply returns an
array of data, which you then enter into multiple cells on your worksheet
using standard Excel array formula notation. Pull up Excel Help and type
"array formulas" in the Answer Wizard to see more about entering and using
array formulas.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Worksheet function - array result, C++ 2
user defined function which increase consecutively while passingbelow cells 12
Function created in VBA not listed in worksheet existing functions.Pleae Help 3
Last Modified By in a cell by user 3
Manipulate cells from UDF 5
Excel VBA help: Text file formatting 19
Create Word Docs From Excel Cell Data 4

Back
Top