Linking Drop Down boxes

[gossv]

Hi,

I am trying to work out how to link drop down or combo boxes so that if I choose an option in one box the second box will only return the choices relevant to the first box.

Ie: I have 5 States and 40 practices. If I choose NSW in the first drop down box I want only the 8 pratices relevant to NSW to show in the second drop down box.

Please help me as this is doing my head in! Thanks.

Ginny

 

[erik.van.geit]

Hi, Ginny,

take a look at this "famous" thread
(the link is already pointed to the "most relevant post")

http://www.mrexcel.com/board2/viewt...=0&postorder=asc&highlight=cascading&start=26

for a technique using comboboxes
http://www.mrexcel.com/board2/viewtopic.php?t=152281&start=5

see also this explanation
http://www.contextures.com/xlDataVal02.html

and
http://www.mrexcel.com/board2/viewtopic.php?t=15030&highlight=
feel free to send an email (no PM)
you'll get three files with examples

subject of email
cascading comboboxes

kind regards,
Erik

 

[gossv]

Thanks Eric,

I'll work through it

 

[erik.van.geit]

you're welcome

leave your own project aside for a while
recontruct some samples litteraly step by step
this has been proven a good way to learn

 

[gossv]

I completely agree. I work off a small sample, get that working then attempt to apply it to the huge amount of data that I'm dealing with! It would help if I knew VBA but I'll wing it! Thanks

 

[erik.van.geit]

I completely agree. I work off a small sample, get that working then attempt to apply it to the huge amount of data that I'm dealing with! It would help if I knew VBA but I'll wing it! Thanks

you can learn VBA when looking to examples
feel free to email (see my first reply)