Linked DropDown's
 

I have two list boxes, A & B. A contains the variables in the left column
(below) ; B contains those in the right column. When a variable from A is
selected, I want to subset the choices in B. And then take specific data
(columns c & D ) about B and enter it into other fields.
A B C D
TRUCKS 1-B 60 1
TRUCKS 1-C 72 2
TRUCKS 1-L 38 3
TRUCKS 1-M 38 5
TRUCKS 1-S 38 7
TRCTRS 2-B 13 3
TRCTRS 2-D 22 2
TRCTRS 2-E 56 4
TRCTRS 2-F 46 5
TRLRS 3-B 102 6
TRLRS 3-D 88 7
AIRSUP 9 65 1
CONST A 23 2
REEFER E 11 4
OTHER Q 5 6
OTHER R 88 9

Could I please get some help with this?

I'm sure this has been asked frequently in the past - and I hate to get
people to do unnecessary work. Is there a website where answers to these
common Excel/VB questions can be just 'looked up'?

Linked DropDown's
 

Hi
as a starting point:
http://www.contextures.com/xlDataVal02.html

--
Regards
Frank Kabel
Frankfurt, Germany

"Jim Berglund" schrieb im Newsbeitrag
...
I have two list boxes, A & B. A contains the variables in the left
column
(below) ; B contains those in the right column. When a variable from
A is
selected, I want to subset the choices in B. And then take specific
data
(columns c & D ) about B and enter it into other fields.
A B C D
TRUCKS 1-B 60 1
TRUCKS 1-C 72 2
TRUCKS 1-L 38 3
TRUCKS 1-M 38 5
TRUCKS 1-S 38 7
TRCTRS 2-B 13 3
TRCTRS 2-D 22 2
TRCTRS 2-E 56 4
TRCTRS 2-F 46 5
TRLRS 3-B 102 6
TRLRS 3-D 88 7
AIRSUP 9 65 1
CONST A 23 2
REEFER E 11 4
OTHER Q 5 6
OTHER R 88 9

Could I please get some help with this?

I'm sure this has been asked frequently in the past - and I hate to
get
people to do unnecessary work. Is there a website where answers to
these
common Excel/VB questions can be just 'looked up'?

Linked DropDown's
 

Many Thanks. It's just what I needed.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!