Have a named range called Entities.
Created a userform with a combobox
The combobox list should be populated with entities
Private Sub UserForm_Initialize()
ComboBox1.List = Range("Entities").Value
However, I recieve an error:424 Object required?
I have a dataset of 70k rows and 40 columns describing 40 different entities, which i am analyzing through a pivot table.
I am trying to make a dashboard where i can describe and compare whichever entities i want through a slicer controlling multiple pivots.