ActiveX Combo box, Values from dynamic range from another sheet

[brendalpzm]

Hello everyone,

Is there a way to populate an activeX combo box with a dynamic range (this means we can add and remove values) that is located in a different sheet,

Also that the combo box is capable of refreshing automatically whenever we add or remove values and ignore blanks.

If you could help me I'd be greatful,

Here are the names of the sheets and combo box

Sheet where the combo box is located: Registro

Combo box name: EmpresaCB

Sheet where the dynamic range is located: DB (Starting from A2)

 

[Fluff]

Duplicate to: Populate an ActiveX combo box with dynamic data from a different sheet

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.