How to get the name of the list that populates a combobox

[Alex Piotto]

Hi everybody.
I have a combobox and 2 buttons.
The buttons tell to the combobox what list to show.
2 buttons, 2 lists. It works.

I need to get the name of the list that is in use by the combobox at a certain moment in order to trigger other events.

how do i do it?

 

[Anthony47]

For example: when you need to check, read which is the starting item in the combobox:

CurList1 = Me.ComboBox1.List(0)

At this point it should be easy to check wether this is on top of list 1 or list 2

Or you save which button sets the list in a shared variable, then when you need to check just read the content of that variable.
If you will check from code that belongs to the userform, you will "Dim" that shared variable at the top of the Userform Vba Module (Dim OneOrTwo). If you need to check from code outside the userform, you need to declare that variable as Public on top of a standad vba module (Public OneOrTwo)

Bye

 

[Alex Piotto]

Hi! Thanks for the tips. I am going to try...

 

[Alex Piotto]

GOT IT! Thanks a lot

 

[Anthony47]

Bene...

 

[Alex Piotto]

grazie...