I am a in need of a VBA macro which could perform the following task
when a macrro is invoked depending upon the fruit all the instances of rate, taste and flavor should be changed in it.
For eg. if fruit is orange, rate should become 24 and flavour tangy
for mango it should 16, sweet
Lemon 12, lemony ...
Plz fwd, ur resonses to this mail id.