Can't you just to a Data/Sort on B4:B100 from the worksheet? If the list is
in sorted order on the sheet, then the RowSource assignment will put them
into the ComboBox in that sorted order.

Rick


wrote in message
ups.com...

Hi, I have a prepared a Userform with many text boxes to retrive my
data in userform from worksheet by using a Combobox. my combobox is
linked to Column B, Range is B4:B100. and I have a List of Material
in B column, but when I Run userform I could not see all the list by
Alphabetically.

My combobox should show all records alphabetically. can anyone help me
in this regard.


COLUMN "B" Contains the following:
---------------------
Water Heaters 300 W
Heating Elements 250 W
Muslim Shower
Laundry Tumbler
Yellow Paint
Blue Paint
Squash Tape
AHU Filter
Fax Machine
Bearing
Brass Holder
ETC....


Private Sub Userform_activate()

ComboBox1.SetFocus
ComboBox1.RowSource = "B4:B100"

End Sub

Pls give me any Idea to sort my combobox A to Z.

Thanks in Advance.



Syed shahzad zafar
Madinah - KSA.