Sort Combobox Items in Userform - shahzad

[shahzad4u_ksa]

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.

 

[Rick Rothstein \(MVP - VB\)]

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

 

[Bob Phillips]

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)

 

[Tom Ogilvy]

If you have a reason not to sort the worksheets, you can use this method by
John Walkenbach. You wold remove the RowSource command you show:

http://www.j-walk.com/ss/excel/tips/tip47.htm

Breaking the rowsource may require you to change the code you currently use
to populate your textboxes.