Dear Friends

When we select a range for combobox. The Selected range shows every row
in the combobox, either there is data in a row or not. How can we show
only filled data rows in a range for ComboBox.

sub userForm_activate

comboBox1.column count = 1
ComboBox1.Rowsource= "a1:a1000"

End sub


--
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=469979