How do I set the ListBox.RowSource automatically if another sheet is added by the user, in the same way that I have the ComboBox automatically populated in the Private Sub UserForm_Initialize module of a UserForm as new sheets might be added.
The Rowsource for each sheet in the listbox is the same range on each sheet.
Any code or suggestions welcome
Thanks
The Rowsource for each sheet in the listbox is the same range on each sheet.
Any code or suggestions welcome
Thanks