Hi everyone,

I am back with a question I asked earlier and didnt receive a response.
Perhaps I didnt explain myself well enough. I will try again. I have 3
spreadsheets in the one workbook. Sheet one has my €œForms-Combo
Box/dropdowns€� in it. (I prefer to use these as I have a number of others
throughout the sheet with quite large VBE data attached to them and rather
than rewrite everything I chose to use the Forms-Combo Box to keep everything
uniform.) Anyway, sheet 2 has my lists in it for the combo boxes and sheet 3
is my data capture sheet.

Sheet 1 €“ Combo box gets list from sheet 2. Combo box is attached to cell C5
in sheet 1.

Sheet 2 €“ has my list going from B1:B15

Sheet 3 €“ I want the cell A1 (sheet3) to pick up the data from cell C5
(sheet1).

I can get a1(sheet3) to recognise the cell C5(sheet1) but it puts the number
of the cell from sheet2 instead of the text, eg In my combo box/dropdown on
sheet 1 I chose €˜Apple which in my list on sheet 2 would be B4. Instead of
showing Apple in Sheet3 A1 it puts the number 4.

I am wanting to capture all the data on a separate sheet in each survey as
this will be going to a large number of people and it will make collating the
data in a master sheet much easier.

BTW I am using Excel 2003.

I hope this makes better sense and someone will be able to help me.

Cheers
Lynda