Listbox Columns - re-arrange order shown

[Pacman52]

Hi

Is it possible to re-arrange the order that columns show in a listbox?

Basically I have a listbox that is showing only 7 out of the 60 odd columns on the worksheet. What I'm trying to accomplish is the order that the column headings are shown when the listbox is opened. So for example the heading are :
'Heading 1', 'Heading 2', 'Heading 3', 'Heading 4', 'Heading 5', 'Heading 6', 'Heading 7',

But when the list box is opened I'd like them to appear
'Heading 7', 'Heading 5', 'Heading 3', 'Heading 1', 'Heading 2', 'Heading 4', 'Heading 6',

Its not a major issue if it can not be done but I'm just trying to make the listbox 'flow' better for the users.

(I do know I can just re-arrange the sheet columns)

Many thanks

Paul

 

[6StringJazzer]

There is no way to do this without either rearranging the sheet columns, or writing code to load the columns instead of using the RowSource property. If you do the latter, you won't get the headings automatically and also have to write the code for that.

 

[Pacman52]

Hi Jeff thanks for the reply as said its not a major issue really so I'll leave it as it is.

Thanks Paul