Sorty by Value

[Softwarez]

Basically i want to hit a button on a form and it sorts a range of cells (in a column going down) in Value order, Lowest at the top, how can this be done? Thankyou.

 

[tactps]

Record a macro in which you select the column and sort it in the order you want.

Then from the View menu, choose toolbars, then "forrms".

Choose the command button and draw it where you want it. It will ask you to assign a macro.

 

[Smitty]

Why not just record sorting the range the way you want and then assign that to a button?

You could do the same if you're talking about a UserForm, but just adding the code to a UF Button Click event.

HTH,

Smitty

 

[Legacy 51064]

You can add this code to a button:


Sub Sort()

'Sort data on Tire shipments based on MSPN

Sheets("Sheet2").Select
Range("B4:R61000").Select
Application.CutCopyMode = False
Selection.Sort Key1:=Range("D4:D61000"), Order1:=xlAscending, Header:=xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom

'Reposition back on Enter
Sheets("Sheet1").Select

End Sub

 

[Softwarez]

Cheers guys