Hi all,

The following code uses the DROPDOWN feature to readily display 25
items of the list.

Private Sub UserForm_Initialize()
With ComboBox1
..RowSource = "a1:f100"
..ColumnCount =6
..listrows=25
..DropDown
End With
End Sub

It works fine except that the list comes detached from the Userform.
Can someone supply a cure such that the list will be properly aligned
on the Userform?

TIA

David


--
davidm
------------------------------------------------------------------------
davidm's Profile: http://www.excelforum.com/member.php...o&userid=20645
View this thread: http://www.excelforum.com/showthread...hreadid=558308