Hi!
How are you?
I really need your help to resolve 1 simple question that will enable me to finish my work.
Question: How can I clear an activex combobox selection with my macros through a VBA sub if i'm not using a form? the activex combobox is in a sheet, without a form.
Basically I have a macro that reads an activex combobox and does something, when it finishes it's job I need the A.C. to go from [ATTACH=CONFIG]73495[/ATTACH] to [ATTACH=CONFIG]73496[/ATTACH], that's it
Background info:
I created 3 buttons to edit, add or delete entries from a list in another sheet acting as a database, the entry to be modified is selected by the user from an activex combobox dropdown list.
The problem is that after the buttons' macro finishes their job, I need the entry selected to not be selected anymore in the activex combobox for 'cleanliness purposes' and to avoid 'layer 8 mistakes', currently the user selection remains there.