Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The code below is part of a macro i am using. In Xl2000 it works fine, but
cannot get it to work in XL97 - need help. Call UpdateSort x = Range("I65536").End(xlUp).Row 'creates multicolumn listbox Dim MyArray() MyArray = Range("I2:J" & x) ListBox1.ColumnWidths = "50;200" Me.ListBox1.List = MyArray columns i:k are sorted into numerical order by the UpdateSort macro i then want listbox1 to show the data in I2:Jx with x being a variable range. I have the listbox set to 2 columns in the properties, but cannot see how to get this to work in XL97 Any help appreciated. George |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
populate multicolumn listbox? | Excel Programming | |||
Hyperlink in multicolumn listbox | Excel Programming | |||
Reordering with Multicolumn Listbox | Excel Programming | |||
Multicolumn Listbox and ordinary listbox | Excel Programming | |||
Values in a MultiColumn Listbox | Excel Programming |