Thread: drop down list
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default drop down list

hi,
put your list some where out of the way. perhaps on a second sheet.
right click your combo box control and from the popup, click properties.
if a form, set the row source property to the range of your list ie
sheet2!A1:A200
if the combo box is on the sheet, set the ListFillRange to the range of your
list.

regards
FSt1
"Khin" wrote:

How to creat the drop down list for 200over products in excel?

Thanks,
Khin