Userform, combobox: Repicking the same selection?

[vrod2000]

I have some program-generated combo boxes on a userform. Each combobox contains a unique list.
Clicking a selection in the list runs a macro that populates cell values on the sheet. (Of course, the user can manually overwrite these values.) The macro only runs when a different choice is made.

I would like the ability, that when the user reselects the same dropdown list selection, the macro would run again. (overwriting the cell values with the default values.)
(currently this only works when the user selects a different choice, then reselects the original choice.)

I appreciate any hints or leads.
I was thinking about a combobox_change event, but not sure if this is correct or how to implement this.

thanks.

 

[DanteAmor]

Hi and welcome to MrExcel board.

The macro only runs when a different choice is made.

You could put a Commandbutton and when pressed execute the macro. That way it is not necessary to change the selection that exists in the combo.

 

[vrod2000]

I thought of that. It just seems more intuitive to just select the same value again and have it refresh. Makes sense to me.