Matt, I have a similar problem and I would like to use the approach you are
suggesting.

I want a drop down on my form to list each sheet name.

Is it possible to add to this and to have another drop down underneath that
which would take the sheet name selected and use values in a dynamic range
on the sheet name selected as entries to the second drop down

So if the sheet name selected is sheet1 and all my sheets have a dynamic
range in row 1 columns B:? (? being the range covered dynamically)

The dynamic range would have to applicable to each sheet found in the first
drop down list not a named dynamic range.

Thanks

Rob

"Matt Lunn" wrote in message
...
Hi,

In a seperate sheet create a list of your worksheet names and give the
list
a defined name.

You can then type this range name into the ListFillRange property
(worksheet control) or RowSource property (userform control).

HTH,
Matt

"SYBS" wrote:

I realise how stupid this seems, but I cant even find information on how
to
create a list box with 8 options in it which when one is selected will
only
show the worksheets relevant to that subject. I have eight sets of
worksheets in the same workbook. each set has an overall title and I
want to
put that title in the list box. I have looked all over for the means of
actually entering the information into a box but its obviously too simple
to
need explaining, except to me! Any one help please?

Thanks