View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default Sorting 3 columns in a 2 dimension array

John,
Just to make sure of the circumstances...
The sort should be accomplished before loading the combobox.
If you have data on a worksheet, then use the VBA Sort Method
to sort the data and then load the combobox.
If you have your data in an array and not on a worksheet then
an array sort routine would be applicable.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"John"
wrote in message
Hello ...
I would like to sort a 3-column combo box list; ordered by Column1
then by Column2 then by Column3.
Have looked at Tom Oglviy's dialogue with Tim Zych (Nov 5, 2002), but
am not sure how to scale the VBA code to accomplish my task.
Would appreciate any help.
John