How to get Excel Table in ComboBox (using VBA only)

[inddon]

Hello There,

I have 2 workbooks (attached sample workbooks):
1. Masterworkbook.xlsx

This file has an excel table called "Tbl_Currency" (below 3 columns) which holds data related to currencies
a. Currency Code
b. Enabled
c. Currency Name


2. Table Combobox.xlsm
Workbook open will open the above file

This file has a Combobox which will display values from the table (1st file), column 'Currency Code'. On Selecting a value from the ComboBox it should display the 'Currency Name' into worksheet Range("FDCurrencyName").

I would like to have this working using VBA only, without the use of additional named ranges. Eg, Arrays, assign combobox.list = [TableName]("Column Name")

By following some websites, I tried some ways in VBA, but it didn't work and cannot go forward.

Could you please advise.

Thanks & regards,
Don

 

[inddon]

I found I was looking for. Thought to share the same with the group.

Please find attached the updated workbook for your reference. If you guys think of a better way, kindly let me know.

Regards,
Don