UDF needs to update cells.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: keepitcool (xrrcvgpbby_at_puryyb.ay)
Date: 06/04/04 

Date: Fri, 04 Jun 2004 06:53:08 -0700

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

Relevant Pages