Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using an Excel macro to reset a drop down list
How do I reset a drop down list to a default, such as "Choose answer," using
a macro. I tried recording it straight forward, but no luck. I'd like the macro to 1) clear the name field (this is a quiz), 2) reset the score to zero and 3) reset the drop down answers for each question to "choose answer." I already have #1 and #2 figured out. Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using an Excel macro to reset a drop down list
It sounds like you already know what the result should be. So rather than
worry about selecting the first item from the validation list, you could just set the proper starting value: Range("A1") = "choose answer" (repeat for each cell that needs to be reset). "BrucenAZ" wrote: How do I reset a drop down list to a default, such as "Choose answer," using a macro. I tried recording it straight forward, but no luck. I'd like the macro to 1) clear the name field (this is a quiz), 2) reset the score to zero and 3) reset the drop down answers for each question to "choose answer." I already have #1 and #2 figured out. Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using an Excel macro to reset a drop down list
I like your idea. However, the drop down lists are not assigned to specific
cells. How do I define the Range of a drop down list? Thanks. "bpeltzer" wrote: It sounds like you already know what the result should be. So rather than worry about selecting the first item from the validation list, you could just set the proper starting value: Range("A1") = "choose answer" (repeat for each cell that needs to be reset). "BrucenAZ" wrote: How do I reset a drop down list to a default, such as "Choose answer," using a macro. I tried recording it straight forward, but no luck. I'd like the macro to 1) clear the name field (this is a quiz), 2) reset the score to zero and 3) reset the drop down answers for each question to "choose answer." I already have #1 and #2 figured out. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel, Macro, Drop down list | Excel Discussion (Misc queries) | |||
Drop down list macro? | Excel Discussion (Misc queries) | |||
Run macro from drop list | Excel Discussion (Misc queries) | |||
How to run different macro from drop-down list ??? | Excel Discussion (Misc queries) | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) |