Dynamically associate a cell with a function

[caio]

Hello all

I am a newcomer into Excel programming (VBA) and most probably my question is not quite challenging:

I want to associate a function to a cell inside VBA, so that if I put an Y (for Yes) in that specific cell it automatically takes the value of other cells around and perform some tasks.

Thanks a lot.

Caio

[TMS]

Look for examples of Worksheet_Change events. That's what you'lll need.

Regards, TMS