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
|