Combobox.Rowsource populated from a database 1

[rafal36]

Hello everyone!
I have a combobox that I want to populate not from a sheet range but from a postgres database query result. Excel Help says that ComboBox.RowSource accepts only ranges from a spreadsheet. Is there a workaround for this to have a combobox populated dynamically by query result?
Thanks for tips,

 

[combo]

Yes, there is:
1. inport your data to the worksheet (data>external data>new database query), one column, no headers, customise query name ('properties..' button after defining data or 'properties' button after import in 'external data' toolbar),
2. refer to the list as to sheet-level named range (SheetName!ExternalDataRangeName).
Adjust refreshing options for the data range.

combo