Populating Combo with values from Excel

r_ganesh76 · February 4th, 2005, 02:22 AM

Hi Experts,

I need some advice from you. I am using Excel for my VBA application. I have a list of cells containing a name/value pair. I want that to be populated into a combobox in one of the sheets. Can anyone put some light on how to achieve this task. I would like to get the code for the same.

Regards
Ganesh

vemaju · February 4th, 2005, 04:33 AM

HI Ganesh

Name your area (name/value pair)
Add combobox to the sheet.
Set ListFillRange to named area.
Set ColumnCount 2 and BoundColumn 1
LinkedCell to any cell you want.

-vemaju

r_ganesh76 · February 4th, 2005, 06:53 AM

Thanx vemaju for your reply. It was very helpful

Regards
Ganesh