Macro and the drop-down list.

[jgowris]

1. I have generated a macro for performing some calculations in the sam
worksheet.

2. The above macro needs to be called, when a value from a dropdow
list (from the same worksheet) is chosen.

Any thoughts on this please.

Thnx,
~Gs. :

 

[Bob Phillips]

If you have Excel 2000 or above, you can tie the macro to a worksheet change
event on that cell.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)