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

One way is to determine the range dynamically:

ComboBox1.RowSource = Range("A1", Range("A1").End(xlDown)).Address

This assumes at least two items in the list.

--
Jim
"Syed Haider Ali"
<Syed.Haider.Ali.1vry2h_1127415944.9738@excelfor um-nospam.com wrote in
message news:Syed.Haider.Ali.1vry2h_1127415944.9738@excelf orum-nospam.com...
|
| 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
|

Thanks Jim Rech. It is working properly


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