View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bobojen
 
Posts: n/a
Default 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