Sort Combobox Items in Userform - shahzad

  • Thread starter Thread starter shahzad4u_ksa
  • Start date Start date
S

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.
 
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
 
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)
 
Back
Top