Combo Box dynamic unique list for input range

[22strider]

Hello Friends

I am preparing a template for which I need a combo box. Becaue it is a template I can't have this combo box any specific input range. Because I won't know how long the data column (that wiill be used for input range) will be.
Also the data column will have many duplicates but the combo box needs to show uniques only.
Could you please nudge me towards right direction?

Thanks
Rajesh

 

[dmt32]

Hello Friends

I am preparing a template for which I need a combo box. Becaue it is a template I can't have this combo box any specific input range. Because I won't know how long the data column (that wiill be used for input range) will be.
Also the data column will have many duplicates but the combo box needs to show uniques only.
Could you please nudge me towards right direction?

Thanks
Rajesh

have a look at sample code here Excel vba: Populate a combo box (form control) | Get Digital Help - Microsoft Excel resource

You can amend code if using an active x control on your worksheet.

Dave