Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Recording a macro to change item selected in drop down list
I am trying to record a macro in Excel that will reset values that are
standard for specific customer programs we have. The worksheet has different data validation drop down lists and the correct selection is different for different programs. Selecting the correct value while recording the macro doesn't seem to work. Is there a special trick to make this happen? Is this even possible? Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Recording a macro to change item selected in drop down list
Can you use a ComboBox instead? It would be something like this:
ActiveSheet.Shapes("Drop Down 1").Select If you really want to go with Data Validation, and you could have a very legitimate reason for this, take a look at this site: http://www.contextures.com/xlDataVal10.html If that doesn't work for you, take a look at this: http://www.contextures.com/tiptech.html There are tons of Data Validation options for you; all arranged in alpha-order. Regards, Ryan--- -- RyGuy "Jen" wrote: I am trying to record a macro in Excel that will reset values that are standard for specific customer programs we have. The worksheet has different data validation drop down lists and the correct selection is different for different programs. Selecting the correct value while recording the macro doesn't seem to work. Is there a special trick to make this happen? Is this even possible? Thanks! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Recording a macro to change item selected in drop down list
I still can't figure out how to make this work. I tried again using a combo
box instead. I really don't know anything about writing code, so the line of code you've written is Greek to me. If you could tell me exactly where I would need to insert the code you've written, and what the commands are doing, that would be great. To be even more clear, I have different macros assigned to various buttons. Depending on the button I select, a number of values are reset in various cells, but I also want it to change the selection in the combo box, or data validation drop down (whichever would work better in this situation). The macro is assigned correctly, because when I push one of the buttons, all of the values change EXCEPT for the selection in the drop down list. I've re-recorded the macro several times to make sure I didn't accidentally miss recording that one action. The links you provided were very interesting and helpful for other things, but didn't help me figure out this issue. Thanks! Jen "ryguy7272" wrote: Can you use a ComboBox instead? It would be something like this: ActiveSheet.Shapes("Drop Down 1").Select If you really want to go with Data Validation, and you could have a very legitimate reason for this, take a look at this site: http://www.contextures.com/xlDataVal10.html If that doesn't work for you, take a look at this: http://www.contextures.com/tiptech.html There are tons of Data Validation options for you; all arranged in alpha-order. Regards, Ryan--- -- RyGuy "Jen" wrote: I am trying to record a macro in Excel that will reset values that are standard for specific customer programs we have. The worksheet has different data validation drop down lists and the correct selection is different for different programs. Selecting the correct value while recording the macro doesn't seem to work. Is there a special trick to make this happen? Is this even possible? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
List and subtotal selected items, then print separate item list | Excel Worksheet Functions | |||
Running a macro when selecting an item in a drop-down list | Excel Discussion (Misc queries) | |||
How to link macro to change an item in drop-down list | Excel Discussion (Misc queries) | |||
How to use a macro to change the selected item in data validation | Excel Discussion (Misc queries) | |||
Calculate Based on Drop Down Item Selected | Excel Worksheet Functions |