Re: Sort Combobox Items in Userform - shahzad

Tech-Archive recommends: Fix windows errors by optimizing your registry

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

Rick


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


.

Quantcast