'Adding datasource to excel combobox

I would like to ask on how can I attach a datasource to combobox... is this possible without using VBA? My colleague gave me a template to pattern my requirements but as I observed, the data required by the combobox is located on a separate sheet. I just can't find how to attached that data source..

here is the example: screenshot from excel

I have tried to use the active x controls and other but can't find on how to attach a data source...

Im hoping for someone to put me in a right direction.

Thanks all!

excelcombobox


Solution 1:[1]

**Please See Thee Screenshot Clear Mention 1 Left Click Combo box Format Control Select Range Of data Source **

enter image description here

enter image description here

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1

Related Questions

Reading Excel file with Selenium WebDriver C# and web form with values

How to update an existing row or table of an existing xlsx file using pyexcel for python

Equivalent C# Function For Excels Norm.S.Inv Function

I keep assigning a value to my variable but it stays empty

Excel RTD (Real Time Data) client other than Excel?

Create table from data on a worksheet with specific name and add column

Is it possible to use 'Microsoft.ACE.OLEDB.12.0' provider without installation?

Using VBA to query a SQL Server table in Excel

How to stop scroll bar auto jump in vba

If IsEmpty then go to column A but in same row and extract that data

How can I use a for each loop on an array?

VBA - worksheet object is hidden

Outlook 2010 GAL with Excel VBA

how to read a value from Column Name in Excel in Java

Replace cell value with image