View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
gregork gregork is offline
external usenet poster
 
Posts: 102
Default Define Range for Combo Box

Is it possible to define a cell range for a combo box list on a user form.
If yes then how would you write the code ? I know I could list with .AddItem
"" but I have a possible list of 200 entries so I'm looking for a shortcut.

regards
GregK