How to show two columns in a combobox from two columns in a table?

[vbaNumpty]

I have set the Column Count to 2 in the properties window of the combobox, but when the code is the following

ComboBox1.List = Sheet2.Range("EmployeeTable[Name]").value

it only shows one column.

I have tried doing this

ComboBox1.List = Sheet2.Range("EmployeeTable[Name]:EmployeeTable[ID#]").value

but I get a range of object worksheet failure.

 

[Fluff]

Try

ComboBox1.List = Sheet2.Range("EmployeeTable[[Name]:[ID#]]").value

 

[vbaNumpty]

Try

ComboBox1.List = Sheet2.Range("EmployeeTable[[Name]:[ID#]]").value

Still a 1004 error.

 

[Fluff]

What is the error message?

 

[vbaNumpty]

What is the error message?

 

[Fluff]

You will need to add a ' before the #

 

[vbaNumpty]

You will need to add a ' before the #

Fluff coming through like always, thanks a bunch.

 

[Fluff]

Glad to help & thanks for the feedback.