Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combobox.additem (No Repeats)
Hi there,
I'm building a Userform with a bunch of Comboboxes which I am populating from a spreadsheet. One of the Combobox is beingin populated by a field which has the majority of the entries the same. Can anyone help with some code to only populate the Combobox with uniqie entries only. Code I have been using to populate the Combobox has been: sub unserform_initialize () a = 2 do until cells(a,1)="" combobox1.additem cells(a,24) a = a+1 loop end sub Thanks Dan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
unique text additem combobox | Excel Programming | |||
additem to combobox with an array | Excel Discussion (Misc queries) | |||
combobox additem | Excel Programming | |||
AddItem Method - Combobox value | Excel Programming | |||
Multiple Column ComboBox using Additem | Excel Programming |