ComboBox1.List = Range("Users").Value


"spence" wrote in message
...
is it possible to add all the items in a range
named "Users" to a combo box with one line of code
instead of having to do a
with combobox
.clear
.additem
.additem
.additem
.additem
.additem
.additem
end with
for like 20 to maybe over 50 items.