I have a dropdown list (let's say no 3.) which is dependent on the selections
of Dropdow list no 1 & 2.

I imagine it would have something to do with multiple if statements but not
very family with VBA.

Thanks in advance.
--
Cheers

Ed

Re: Dependent Dropdown list by Doug

Doug
Mon Aug 13 03:57:40 CDT 2007

See the Cascading Listboxes section of the
following page on fellow MVP Greg Maxey's website:

http://gregmaxey.mvps.org/Populate_UserForm_ListBox.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Ted" <Ted@discussions.microsoft.com> wrote in message
news:BCB04995-5732-4851-856C-D8E4A0265CAA@microsoft.com...
>I have a dropdown list (let's say no 3.) which is dependent on the
>selections
> of Dropdow list no 1 & 2.
>
> I imagine it would have something to do with multiple if statements but
> not
> very family with VBA.
>
> Thanks in advance.
> --
> Cheers
>
> Ed



Re: Dependent Dropdown list by Ted

Ted
Sun Aug 19 21:52:18 CDT 2007

Can I use if fields using the information that has been selected in the list
boxes. If so is it as easy as { IF {Listbox2 } ="TEXT" "{ INCLUDETEXT "..."}"}
--
Cheers
Ed


"Doug Robbins - Word MVP" wrote:

> See the Cascading Listboxes section of the
> following page on fellow MVP Greg Maxey's website:
>
> http://gregmaxey.mvps.org/Populate_UserForm_ListBox.htm
>
>
> --
> Hope this helps.
>
> Please reply to the newsgroup unless you wish to avail yourself of my
> services on a paid consulting basis.
>
> Doug Robbins - Word MVP
>
> "Ted" <Ted@discussions.microsoft.com> wrote in message
> news:BCB04995-5732-4851-856C-D8E4A0265CAA@microsoft.com...
> >I have a dropdown list (let's say no 3.) which is dependent on the
> >selections
> > of Dropdow list no 1 & 2.
> >
> > I imagine it would have something to do with multiple if statements but
> > not
> > very family with VBA.
> >
> > Thanks in advance.
> > --
> > Cheers
> >
> > Ed
>
>
>

Re: Dependent Dropdown list by Doug

Doug
Mon Aug 20 00:04:15 CDT 2007

I would not say that you cannot, but it would not be the best way.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Ted" <Ted@discussions.microsoft.com> wrote in message
news:9A53F3DE-1B93-47D6-BE00-D07770BDC115@microsoft.com...
> Can I use if fields using the information that has been selected in the
> list
> boxes. If so is it as easy as { IF {Listbox2 } ="TEXT" "{ INCLUDETEXT
> "..."}"}
> --
> Cheers
> Ed
>
>
> "Doug Robbins - Word MVP" wrote:
>
>> See the Cascading Listboxes section of the
>> following page on fellow MVP Greg Maxey's website:
>>
>> http://gregmaxey.mvps.org/Populate_UserForm_ListBox.htm
>>
>>
>> --
>> Hope this helps.
>>
>> Please reply to the newsgroup unless you wish to avail yourself of my
>> services on a paid consulting basis.
>>
>> Doug Robbins - Word MVP
>>
>> "Ted" <Ted@discussions.microsoft.com> wrote in message
>> news:BCB04995-5732-4851-856C-D8E4A0265CAA@microsoft.com...
>> >I have a dropdown list (let's say no 3.) which is dependent on the
>> >selections
>> > of Dropdow list no 1 & 2.
>> >
>> > I imagine it would have something to do with multiple if statements but
>> > not
>> > very family with VBA.
>> >
>> > Thanks in advance.
>> > --
>> > Cheers
>> >
>> > Ed
>>
>>
>>



Re: Dependent Dropdown list by Ted

Ted
Mon Aug 20 00:16:00 CDT 2007

Would you have any alternative(s) in mind?
--
Cheers
Ed


"Doug Robbins - Word MVP" wrote:

> I would not say that you cannot, but it would not be the best way.
>
> --
> Hope this helps.
>
> Please reply to the newsgroup unless you wish to avail yourself of my
> services on a paid consulting basis.
>
> Doug Robbins - Word MVP
>
> "Ted" <Ted@discussions.microsoft.com> wrote in message
> news:9A53F3DE-1B93-47D6-BE00-D07770BDC115@microsoft.com...
> > Can I use if fields using the information that has been selected in the
> > list
> > boxes. If so is it as easy as { IF {Listbox2 } ="TEXT" "{ INCLUDETEXT
> > "..."}"}
> > --
> > Cheers
> > Ed
> >
> >
> > "Doug Robbins - Word MVP" wrote:
> >
> >> See the Cascading Listboxes section of the
> >> following page on fellow MVP Greg Maxey's website:
> >>
> >> http://gregmaxey.mvps.org/Populate_UserForm_ListBox.htm
> >>
> >>
> >> --
> >> Hope this helps.
> >>
> >> Please reply to the newsgroup unless you wish to avail yourself of my
> >> services on a paid consulting basis.
> >>
> >> Doug Robbins - Word MVP
> >>
> >> "Ted" <Ted@discussions.microsoft.com> wrote in message
> >> news:BCB04995-5732-4851-856C-D8E4A0265CAA@microsoft.com...
> >> >I have a dropdown list (let's say no 3.) which is dependent on the
> >> >selections
> >> > of Dropdow list no 1 & 2.
> >> >
> >> > I imagine it would have something to do with multiple if statements but
> >> > not
> >> > very family with VBA.
> >> >
> >> > Thanks in advance.
> >> > --
> >> > Cheers
> >> >
> >> > Ed
> >>
> >>
> >>
>
>
>

Re: Dependent Dropdown list by Doug

Doug
Mon Aug 20 05:39:21 CDT 2007

Yes, the link that I included in my response to your original post:

See the Cascading Listboxes section of the
following page on fellow MVP Greg Maxey's website:

http://gregmaxey.mvps.org/Populate_UserForm_ListBox.htm

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Ted" <Ted@discussions.microsoft.com> wrote in message
news:7CC8D72C-89D4-47E9-894E-7E124AC7BAB2@microsoft.com...
> Would you have any alternative(s) in mind?
> --
> Cheers
> Ed
>
>
> "Doug Robbins - Word MVP" wrote:
>
>> I would not say that you cannot, but it would not be the best way.
>>
>> --
>> Hope this helps.
>>
>> Please reply to the newsgroup unless you wish to avail yourself of my
>> services on a paid consulting basis.
>>
>> Doug Robbins - Word MVP
>>
>> "Ted" <Ted@discussions.microsoft.com> wrote in message
>> news:9A53F3DE-1B93-47D6-BE00-D07770BDC115@microsoft.com...
>> > Can I use if fields using the information that has been selected in the
>> > list
>> > boxes. If so is it as easy as { IF {Listbox2 } ="TEXT" "{ INCLUDETEXT
>> > "..."}"}
>> > --
>> > Cheers
>> > Ed
>> >
>> >
>> > "Doug Robbins - Word MVP" wrote:
>> >
>> >> See the Cascading Listboxes section of the
>> >> following page on fellow MVP Greg Maxey's website:
>> >>
>> >> http://gregmaxey.mvps.org/Populate_UserForm_ListBox.htm
>> >>
>> >>
>> >> --
>> >> Hope this helps.
>> >>
>> >> Please reply to the newsgroup unless you wish to avail yourself of my
>> >> services on a paid consulting basis.
>> >>
>> >> Doug Robbins - Word MVP
>> >>
>> >> "Ted" <Ted@discussions.microsoft.com> wrote in message
>> >> news:BCB04995-5732-4851-856C-D8E4A0265CAA@microsoft.com...
>> >> >I have a dropdown list (let's say no 3.) which is dependent on the
>> >> >selections
>> >> > of Dropdow list no 1 & 2.
>> >> >
>> >> > I imagine it would have something to do with multiple if statements
>> >> > but
>> >> > not
>> >> > very family with VBA.
>> >> >
>> >> > Thanks in advance.
>> >> > --
>> >> > Cheers
>> >> >
>> >> > Ed
>> >>
>> >>
>> >>
>>
>>
>>