| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calling an Excel function from a VBA macro | Excel Programming | |||
| calling excel macro | Excel Programming | |||
| calling macro in excel from VB program | Excel Programming | |||
| Calling Excel Macro From Vc++ via DDE | Excel Programming | |||
| calling a dll from excel macro | Excel Programming | |||
Hybrid Mode
