Can UDF entered as a formula in names return a value to VBA?
 

I've "borrowed" daughters account as Boooble bungled mine ...

I've got a function requiring a user to enter a table and my UDF needs to know when the table gets changed/updated. It can then be uploaded and used as a public table which should speed up the spreadsheet.

So far, the main idea is to run a simple checksum algorithm on it, but I'm trying to avoid placing the checksum under the table or "invisible" on a sheet, instead thinking to place it as a formula in names.

It's there, but when I try to "get" the return, it ends up being the formula, not the executed function.

I like the idea of using the names domain because I can check if it exists to facilitate initialization (function tells user to enter a keystroke to invoke a macro, which sorts the keys table, etc. and creates/runs the checksum).

Can I execute the function in names, will it update, or does anyone have any suggestion that will allow for the same initialization senerio?

TIA,
KK's Daddah