drop down list
 

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

Thanks,
Khin

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