I have developed a spreadsheet in excel that in one column (column "F") has a
dropdown box of choices. I then have written a macro to convert any choice
(in this case all weight measurements) to ounces. How can I call the macro
whenever a choice or new choice is made in the dropdown box? I will also
need to pass the row number to the macro as the user moves down the page.
Thank you in advance to all your help!

Use a worksheet change event macro.
--
Gary''s Student - gsnu200767


"Rodney Crow" wrote:

> I have developed a spreadsheet in excel that in one column (column "F") has a
> dropdown box of choices. I then have written a macro to convert any choice
> (in this case all weight measurements) to ounces. How can I call the macro
> whenever a choice or new choice is made in the dropdown box? I will also
> need to pass the row number to the macro as the user moves down the page.
> Thank you in advance to all your help!