Stop combobox from sorting

[davesexcel]

Hello,
First post, the combobox keeps displaying as a sorted list, and not in the order the list was written.

Code: Select all

WS.AddText("T_Depth", TX, 30, TW, TH, "Depth",,,,,, "Right")
WS.AddCombobox("C_Depth", EX, EY, EW,, "9 1/2""|11 7/8""|14""|16""|18""",,,, "I" Row)

How do I get the combobox to show in the list order and not in a sorted order?

[gregster]

Is this Excel-Com-related?

[davesexcel]

The code eventually opens a workbook template, right now the ws is a variable

Code: Select all

WS := MyTabs.TabList[2].Workspace

[davesexcel]

Thanks, it I found a line where the default was to sort.