Combobox rowsource sort

jgoulart · Mar 4th, 2002, 06:27 PM

How can I sort the rowsource of combobox? Right now I am using a named range as rowsource. do I have to sort it prior to defining it or can I have it temporarily sorted for display purposes in my combobox?

John

Anne Troy · Mar 4th, 2002, 06:28 PM

Is it a real combobox or a data-validation list box?

jgoulart · Mar 4th, 2002, 06:56 PM

It is called out as a combobox but I guess, I am using it like a listbox. List values that are in a named range and take data from the column to the right of the displayed value.

Dave Hawley · Mar 4th, 2002, 07:53 PM

I have some sample code here that adds a sorted list to a listBox (or Combobox) and also removes duplicates.

http://www.ozgrid.com/VBA/UserForms.htm

Mar 4th, 2002, 06:28 PM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	Is it a real combobox or a data-validation list box? __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 4th, 2002, 06:27 PM	#1
jgoulart Board Regular Join Date: Feb 2002 Location: John G Posts: 62	How can I sort the rowsource of combobox? Right now I am using a named range as rowsource. do I have to sort it prior to defining it or can I have it temporarily sorted for display purposes in my combobox? John

Mar 4th, 2002, 06:56 PM	#3
jgoulart Board Regular Join Date: Feb 2002 Location: John G Posts: 62	It is called out as a combobox but I guess, I am using it like a listbox. List values that are in a named range and take data from the column to the right of the displayed value.

Mar 4th, 2002, 07:53 PM	#4
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	I have some sample code here that adds a sorted list to a listBox (or Combobox) and also removes duplicates. http://www.ozgrid.com/VBA/UserForms.htm