Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Combobox
I have inserted a combobox on a worksheet using the control toolbox, and
subsequently attached a macro to it. Why is it when an item from the drop down list is already selected, and the same item is then reselected the macro does not activate? |
#2
|
|||
|
|||
If you're using the "ComboBox1_Change" event, then you're not really changing
the value--so it doesn't fire. You may want to consider putting a button next to the dropdown and have the user click that when they need to run it again. (and remove it from the _change event). Or reset the combobox when your code finishes. (If your list is extremely long, the user will have to scroll down again, though.) nc wrote: I have inserted a combobox on a worksheet using the control toolbox, and subsequently attached a macro to it. Why is it when an item from the drop down list is already selected, and the same item is then reselected the macro does not activate? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Newbie combobox ordeal. | New Users to Excel | |||
Combobox Number Formats | Excel Worksheet Functions | |||
Using a ComboBox for Data Entry into a Cell | Excel Worksheet Functions | |||
Combobox | Excel Discussion (Misc queries) | |||
Getting combobox dropdowns to appear on a userform when tabbed to. | Excel Discussion (Misc queries) |