View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
spence[_3_] spence[_3_] is offline
external usenet poster
 
Posts: 15
Default add a range of items to a combobox

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.