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

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

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

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.

--
Kind regards,

Niek Otten

"Vinay" wrote in message
...
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

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

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

"Niek Otten" wrote:

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.

--
Kind regards,

Niek Otten

"Vinay" wrote in message
...
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