Is this possible?
Is it possible too sort from userform
-
-
-
Re: Is it possible too sort from userform
Possible
-
Re: Is it possible too sort from userform
Cross post perhaps
-
Re: Is it possible too sort from userform
Re your PM
If you understand why you should not cross post, take an action as per the rule.
I will unlock the code then.
-
Re: Is it possible too sort from userform
Yes I did CrossPost http://%22http//www.mrexcel.c…on-sort.html%22
I was having no luck at the other site because you can not load attachments. I came here with a attachment for help, Jindon did have a fix. I will delete my bookmark to the other site and only
ask for help here. I know it wastes the time of members when I cross post. Not sure what else I can say, but it will not happen again. If it does the site should band me for 60 days.
Z -
-
Re: Is it possible too sort from userform
Thanks for the link.
Here's the code
Code
Display MorePrivate Sub UserForm_Initialize() With Sheets("sheet2") Me.ListBox1.RowSource = "" Me.ListBox1.List = .Range("a1", .Range("a" & Rows.Count).End(xlUp)).Value End With End Sub Private Sub CommandButton1_Click() Dim a, e With Me.ListBox1 a = .List With CreateObject("System.Collections.ArrayList") For Each e In a .Add e Next .Sort a = .ToArray End With .List = a End With End Sub
-
Re: Is it possible too sort from userform
There is nothing incorrect with a cross post if you include links to both forums. Sometimes I too forget. . .it happens. I have been reprimanded but yet to have been spanked.
Streub
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!