List box based off different sheet

[kosherboy]

Hello.
How do I base the fill range in a list box off a different sheet in the same workbook?

[cffndncr]

Right click on the list box, and click 'Format Control'

Then in the input range, input XXXXXX!YYYYYYY, where XXXXX is your sheet name and YYYYY is your range (such as Sheet2!A1:A10)

[rjm87]

Do you mean a dropdown list ?

[kosherboy]

that's exactly what i tried before I started this thread but it didn't work.

any other ideas?

[cffndncr]

Any chance you could upload your workbook? I tried it in a sample workbook and it worked just fine.

[kosherboy]

Hi.
I apologize for the delay, vacation
Here is a sample with a list box in sheet1 which I would like to be referred to the range in sheet2Test1.xlsx

Thanks.