View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
keepITcool keepITcool is offline
external usenet poster
 
Posts: 2,253
Default UDF needs to update cells.

i need an answer...

keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


keepitcool wrote:


I've created an UDF to retrieve an array from an external app.

My users must be able to use the UDF's results as the source for
a DataValidation object with Dropdown list.

AFAIK Data Validation list source will only accept a "flat" delimited
string or a range object.
If the range is external a Name object is used as a wrapper for the
range.


So : I'm forced to create an UDF that returns a range on a worksheet
within my addin called wsCache.

However if the lists needs to be refreshed:
I can run external application to retrieve a new array..
If the function is called from within the VBE all is fine and the
cells in wsCache can be rewritten.

But if the function is called from a cell e.g.
vartype(application.caller) = "Range" then my function exits when it
tries to write to wsCache.

Any ideas..solutions..suggestions?

keepITcool
amsterdam
mailROT13