Conditional Use of List box (drop down)

I am able to define and use list boxes (defining a name for data range)
individually. I would like to be able to have a user select an option from a
master list and, dependent on this selection, display a new list box,
adjacent cell, that has options related to the first selection. Can anyone
help. Thanks (not a coder, sorry)

Application - master list has Company Division selection and then have set
up multiple list boxes that hold job functions against each division option.
If user selects Project Office, from main list, I would like adjacent cell to
display the drop down list I have defined as Project and so on

I have done something but my list box related back to a database. I did it
by writing a loop that parses through all the entries in the list box and
when it finds one that was selected by the user it assigns it to variable.
After it is assigned to variable, you can input it into a statement that
calls some data related to the selection: Here is the loop

Public Function ChooseType()
Dim h As Integer
Dim Typ As String
For h = 0 To Sheets("Program").LstChoices.ListCount - 1
If Sheets("Program").LstChoices.Selected(h) Then _
Typ = Typ & Sheets("Program").LstChoices.List(h)
ChooseType = Typ
Next h
End Function

"Crispy" wrote:

> I am able to define and use list boxes (defining a name for data range)
> individually. I would like to be able to have a user select an option from a
> master list and, dependent on this selection, display a new list box,
> adjacent cell, that has options related to the first selection. Can anyone
> help. Thanks (not a coder, sorry)
>
> Application - master list has Company Division selection and then have set
> up multiple list boxes that hold job functions against each division option.
> If user selects Project Office, from main list, I would like adjacent cell to
> display the drop down list I have defined as Project and so on

See http://www.contextures.com/xlDataVal02.html

and

http://www.xldynamic.com/source/xld.Dropdowns.html

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Crispy" <Crispy@discussions.microsoft.com> wrote in message
news:8483D4F1-7D6C-4F87-B5E4-7925E8EE6A59@microsoft.com...
> I am able to define and use list boxes (defining a name for data range)
> individually. I would like to be able to have a user select an option from
a
> master list and, dependent on this selection, display a new list box,
> adjacent cell, that has options related to the first selection. Can anyone
> help. Thanks (not a coder, sorry)
>
> Application - master list has Company Division selection and then have set
> up multiple list boxes that hold job functions against each division
option.
> If user selects Project Office, from main list, I would like adjacent cell
to
> display the drop down list I have defined as Project and so on