Combo Box

D

Donovan

Using a combobox on 1st sheet in a worbook, how can I use it to display data
in a column from sheet 2 in the same workbook?
 
K

krcowen

Donovan

Give the area of sheet2 that you want to include in the combobox
display data a range name, for example "data", then make "data" the
ListFillRange for the combobox on sheet1, but, editing the properties
box for the combobox.

Good luck.

Ken
Norfolk, Va
 
Top