How to make custom functions (VBA) read changes automatically?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Vinay - 21 Feb 2006 10:48 GMT

Kindly help me on this. I have a function (VBA) which automatically runs the
mundane checks for data in a given sheet and runs a VLOOKUP on that sheet.
This is specific to the financial model that I am building. But, the only
concern here is that, it doesnot recognise the value changes until I manually
go to each cell and say "F2" followed by an enter. Kindly help me with this

Reply to this Message

Niek Otten - 21 Feb 2006 10:58 GMT

All data that the function needs should be supplied via the argument list in
the function call (and the function definition, of course)

You can also add "Application.Volatile" to the function, but really the
safest way is to include all input in the arguments.

Signature

Kind regards,

Niek Otten

> Kindly help me on this. I have a function (VBA) which automatically runs
> the
[quoted text clipped - 4 lines]
> go to each cell and say "F2" followed by an enter. Kindly help me with
> this

Reply to this Message

Vinay - 21 Feb 2006 11:40 GMT

Hello Niek,

Thanks a lot for that simple piece of information. You really made my day.
If not for this I would started with the VLOOKUP function all over again.

Thanks once again!!!

Regards,
Vinay

> All data that the function needs should be supplied via the argument list in
> the function call (and the function definition, of course)
[quoted text clipped - 10 lines]
> > go to each cell and say "F2" followed by an enter. Kindly help me with
> > this

Reply to this Message