Combo Box & Array???
 

I have 2 combo boxes on Sheet1.

The first ones input range is
Sheet3!$C$5:$C$8 (letters, numbers, tens, capital letters)

I would like the second combo box to return specific values when the
first box one has a value picked (I have the values below on
Sheet2)(when "letters" is picked in the first box, i want the second
combo box to return only a,b & c)

EG:
letters=a,b,c
numbers=1,2,3
tens=10,20,30
Capital Letters=A,B,C

Thanks for any help!
Jennifer


--
bobojen
------------------------------------------------------------------------
bobojen's Profile: http://www.excelforum.com/member.php...fo&userid=6477
View this thread: http://www.excelforum.com/showthread...hreadid=533436

Combo Box & Array???
 

Create a range called letters with a,bc, numbers with 1,2,3, etc. (call
capital_letters capital_letters), and then use

Private Sub ComboBox1_Click()
ComboBox2.ListFillRange = Range(Replace(ComboBox1.Value, " ",
"_")).Address
End Sub


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"bobojen" wrote in
message ...

I have 2 combo boxes on Sheet1.

The first ones input range is
Sheet3!$C$5:$C$8 (letters, numbers, tens, capital letters)

I would like the second combo box to return specific values when the
first box one has a value picked (I have the values below on
Sheet2)(when "letters" is picked in the first box, i want the second
combo box to return only a,b & c)

EG:
letters=a,b,c
numbers=1,2,3
tens=10,20,30
Capital Letters=A,B,C

Thanks for any help!
Jennifer


--
bobojen
------------------------------------------------------------------------
bobojen's Profile:
http://www.excelforum.com/member.php...fo&userid=6477
View this thread: http://www.excelforum.com/showthread...hreadid=533436

Combo Box & Array???
 

Jennifer,
Take a look at:

http://www.contextures.com/xlDataVal13.html

"bobojen" wrote:


I have 2 combo boxes on Sheet1.

The first ones input range is
Sheet3!$C$5:$C$8 (letters, numbers, tens, capital letters)

I would like the second combo box to return specific values when the
first box one has a value picked (I have the values below on
Sheet2)(when "letters" is picked in the first box, i want the second
combo box to return only a,b & c)

EG:
letters=a,b,c
numbers=1,2,3
tens=10,20,30
Capital Letters=A,B,C

Thanks for any help!
Jennifer


--
bobojen
------------------------------------------------------------------------
bobojen's Profile: http://www.excelforum.com/member.php...fo&userid=6477
View this thread: http://www.excelforum.com/showthread...hreadid=533436