Populating ListBox with ComboBox selection

[Boechat]

Greetings everyone,

I'm trying to populate ListBox1 on my user form with the information in columns A and B from different sheets.
For this I have a ComboBox1 containing the names of all sheets in the workbook.
For instance, my ComboBox loads "Sheet1", "Sheet2", etc.

I want to, upon changing my ComboBox.value for the List to be filled with all rows populated (dynamic ranges) in the corresponding Sheet.


Can you help me out?

 

[Fluff]

Maybe

Private Sub ComboBox1_Change()
   Me.ListBox1.Clear
   With Sheets(Me.ComboBox1.Value)
      Me.ListBox1.List = .Range("A1", .Range("A" & Rows.Count).End(xlUp).Offset(, 1)).Value
   End With
End Sub

 

[Boechat]

Worked fine! Thank you

SOLVED

 

[Fluff]

You're welcome & thanks for the feedback