Emoncada
03-19-2015, 06:10 AM
I have created a userform that I would like to be able to have it reflect Activesheet.name in a Combobox.
The hard part is I have a commandButton that creates a new sheet, What I would like is to have that name added to that Combobox.
So that the user can change sheets by selecting from the ComboBox.
So as they use the userform and add more sheets, they can change from one sheet to another from that combobox.
Any help would be great.
Thanks,
The hard part is I have a commandButton that creates a new sheet, What I would like is to have that name added to that Combobox.
So that the user can change sheets by selecting from the ComboBox.
So as they use the userform and add more sheets, they can change from one sheet to another from that combobox.
Any help would be great.
Thanks,