Combo Box & Array???

  • Thread starter Thread starter bobojen
  • Start date Start date
B

bobojen

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
 
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)
 
Back
Top