Calling a macro in excel
 

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!

Calling a macro in excel
 

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!