Combo Box - AfterUpdate
 

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 |
+-------------------------------------------------------------------+

--
TheLeafs
------------------------------------------------------------------------
TheLeafs's Profile: http://www.excelforum.com/member.php...o&userid=10131
View this thread: http://www.excelforum.com/showthread...hreadid=545487

Combo Box - AfterUpdate
 

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
--
AP

"TheLeafs" a écrit
dans le message de news:
...

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 |
+-------------------------------------------------------------------+

--
TheLeafs
------------------------------------------------------------------------
TheLeafs's Profile:
http://www.excelforum.com/member.php...o&userid=10131
View this thread: http://www.excelforum.com/showthread...hreadid=545487

Combo Box - AfterUpdate
 

Hey Ardus,

Thank you for your help.

Chris


--
TheLeafs
------------------------------------------------------------------------
TheLeafs's Profile: http://www.excelforum.com/member.php...o&userid=10131
View this thread: http://www.excelforum.com/showthread...hreadid=545487

Combo Box - AfterUpdate
 

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


--
TheLeafs
------------------------------------------------------------------------
TheLeafs's Profile: http://www.excelforum.com/member.php...o&userid=10131
View this thread: http://www.excelforum.com/showthread...hreadid=545487

Combo Box - AfterUpdate
 

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

--
AP

"TheLeafs" a écrit
dans le message de news:
...

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


--
TheLeafs
------------------------------------------------------------------------
TheLeafs's Profile:
http://www.excelforum.com/member.php...o&userid=10131
View this thread: http://www.excelforum.com/showthread...hreadid=545487