Combo Box - AfterUpdate

[TheLeafs]

Good day,

I am attempting to develop a project for school with three Combo Boxes
that will update upon user selection. Esstinally when I select the
first combo box, I was looking to get the data assocated with that
selection to populate automatically. I know this will be a VB/Macro
type of situation but I am not sure of the code or how I should setup
my source data. I have attached the file, if someone can help me out it
would be great.

Chris


+-------------------------------------------------------------------+
|Filename: Cars.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4810 |
+-------------------------------------------------------------------+

 

[Ardus Petus]

Here is the answer: http://cjoint.com/?fzq3JGEvsg

Right-click on Main tab, select View Code
here is the code.

It just does an AdvancedFilter on your data

HTH

 

[TheLeafs]

Hey Ardus,

Thank you for your help.

Chris

 

[TheLeafs]

Hi again,

When I put the code my file I get the "The extract range has a missing
or illegal field name", do you know what would casuse this error?

Chris

 

[Ardus Petus]

Because (as in my example), the row headers like "# of calls" must contain
no spaces (use" _" instead)