Re: Sort Combobox Items in Userform - shahzad

Sort the source data if you want it sorted in the Combo.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

<shahzad4u_ksa@xxxxxxxxx> wrote in message
news:1183305737.700470.32070@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Hi, I have a prepared a Userform with many text boxes to retrive my
data in userform from work*** 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.



.