Fill a ComboBox with a column of a PowerQuery table in VBA

[3gustavo]

I want to fill a ComboBox with a data of a column that is in a table of the PowerQuery. I tried this, but is not working:

Private Sub UserForm_Initialize()

Me.ComboBox1.RowSource = Thisworkbook.Queries("Table1").Columns("Code").DataBody

End Sub

Can someone help me, please?

 

[3gustavo]

I want to fill a ComboBox with a data of a column that is in a table of the PowerQuery. I tried this, but is not working:

Private Sub UserForm_Initialize()

Me.ComboBox1.RowSource = Thisworkbook.Queries("Table1").Columns("Code").DataBody

End Sub

Can someone help me, please?