Tying Data to Combo Box

[ChuckW]

Hi,

I have Excel 2002 and have a chart of data with two
columns and 15 rows on Sheet2. What I want to do is to
create a spreadsheet on Sheet1 that references the two
columns of data in Sheet2. I want to create combo boxes
on sheet1 which will allow someone to select the values
from Sheet2. I know how to use the control toolbox and
select a combo box and place it in a cell but I am having
trouble tying the combo box to my data on sheet2.

Can anyone help?

Chuck

 

[JulieD]

Hi Chuck

check out Data Validation on Debra Dalgleish's site - i think it might work
for what you're after
www.contextures.com/tiptech.html

Cheers
JulieD