A B C D E F G
1Product
Code PoolMth SUPER EARLY STD LATE Expiration
2CODE1 01/06 12/9 12/16 12/23 1/3 1/9
3CODE2 12/6 12/13 12/20 12/28 1/4
4CODE3 12/6 12/13 12/20 12/28 1/4
5CODE4 N/A N/A 12/20 12/28 1/4
6CODE5 11/30 12/7 12/14 12/21 12/28
7CODE6 12/5 12/12 12/19 12/27 1/3
8CODE7 11/30 12/7 12/14 12/21 12/28
9CODE8 12/5 12/12 12/19 12/27 1/3
10 PoolMth SUPER EARLY STD LATE Expiration
11CODE1 02/06 1/11 1/18 1/25 2/1 2/7
12CODE2 1/6 1/13 1/20 1/27 2/2
13CODE3 1/9 1/16 1/23 1/30 2/3
14CODE4 N/A N/A 1/20 1/27 2/2
15CODE5 1/3 1/10 1/17 1/24 1/30
16CODE6 1/6 1/13 1/20 1/27 2/2
17CODE7 1/3 1/10 1/17 1/24 1/30
18CODE8 1/6 1/13 1/20 1/27 2/2
19 PoolMth SUPER EARLY STD LATE Expiration
20CODE1 03/06 2/9 2/16 2/23 3/2 3/8
21CODE2 2/6 2/13 2/20 2/27 3/3
22CODE3 2/6 2/13 2/20 2/27 3/3
23CODE4 N/A N/A 2/20 2/27 3/3
24CODE5 1/31 2/7 2/14 2/21 2/27
25CODE6 2/3 2/10 2/17 2/24 3/2
26ODE7 1/31 2/7 2/14 2/21 2/27
27CODE8 2/3 2/10 2/17 2/24 3/2


I have a Table on Sheet 1 and User Form on Sheet2

When the User picks (Column A)ProductCode(ComboBox1)-Code1(A2)
and (ColumnB)PoolMth(ComboBox2) -01/06(B2)

then have ComboBox3 Show Range (C2:F2)
and ComboBox4 Show Range G2.


Question is how to connect information to comboboxes and have
ComboBox3 and ComboBox4 depend on what was picked in ComboBox1 and ComboBox2.

Example is, when you pick Code1- PoolMth 01/06, then have range of C2:F2
show in ComboBox3 and ComboBox4 show G2.

Any help would greatly be appreciated.






--
ca1358