Dependent Dropdown list

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

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" wrote in message
...
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

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" wrote in message
...
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

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" wrote in message
...
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" wrote in message
...
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

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" wrote in message
...
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" wrote in message
...
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

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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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