Dropdown list???

[PeterG]

I've created a drop down list, it lives on the same sheet that the dropdown is used on. Is there anyway that I can get the dropdown to use a list from a different worksheet - if so whats the format? I cant work it out.

Peter.

[Gary Brown]

The format is:-

[Workbook name]Sheetname!A1:A3

A1:A3 being the cell references, which are probabaly better off being replaced by a named range.

[PeterG]

Hi,

That does not appear to let me fill in the ListFillRange in properties of the combobox.

[PeterG]

Got it sussed out ... I created a named range, then in the ListFillRange - entered the name of the named range - hey presto bobs your uncle it works a treat.