Hi Dears,

I want to build two Combo Boxes i.e ComboBox1 having range "a1: a50"
and ComboBox2 having range "c1:c25". on a same userForm.

for a simple single comboBox we use these codes

Private sub userForm_activate()

Sheet1.activate
ComboBox1.columncount=1
Combobox1.rowsource="a1:a50"

end sub

but i need code to show Combobox2 on the same userForm have range
"c1:c25" as well as combobox1 having range "a1:a50".



Thanks

Syed Haider Ali


--
Syed Haider Ali
------------------------------------------------------------------------
Syed Haider Ali's Profile: http://www.excelforum.com/member.php...o&userid=21994
View this thread: http://www.excelforum.com/showthread...hreadid=467474