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!