This is a logical function question.
I have a user form with a combobox drop down list of items. I have a macro that is activated when one of the items, "Continued", is selected. However I would like a macro to be activated when the user decides to select a different item - changed from "Continued" - to another value in the combobox. A change of item to any other item from any other item does not activate a macro.
to help explain myself I came up with this macro:
Please feel free to ask any question.
Thank you!
Nicole
I have a user form with a combobox drop down list of items. I have a macro that is activated when one of the items, "Continued", is selected. However I would like a macro to be activated when the user decides to select a different item - changed from "Continued" - to another value in the combobox. A change of item to any other item from any other item does not activate a macro.
to help explain myself I came up with this macro:
Code:
If Combobox1.Value = "Continued" Then
Macro1
if Combobox1.Value = any value changed FROM "continued" then
Macro2
if Combobox1.Value = any value but "Continued" FROM any value but "Continued" then
do nothing
Please feel free to ask any question.
Thank you!
Nicole