View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] li.yuanyuan.li@gmail.com is offline
external usenet poster
 
Posts: 1
Default How to add an array to a combo box with Excel 2003?

Hello guys,

I am very new at VBA, and just got a project that requires adding a
combo box to a "FORM" in VBA. I have this long list of ppl's names,
and hoping to some how organize it into a drop down list. I think I
should either use combo box or list box. I know how to do it with a
combo box, (when you have a few items to add), but I have 65 names, I
do not want to add it one by one , it is going to take too long and
sounds very tedious. I tried to search in the help, but did not find
any example with an arry added to a combo box.

Does anyone know how to do it??

Thanks!