Macro for a button

[Wayne H]

Hi,
I am wanting a button in a sheet (excel 2003) with a macro or command to select a group of cells and then put the data in ascending order.

I have been able to insert the button but do not know where to go from here.

I have no experiance with macro or visual basic.

Any assistance apreciated.

 

[jreedich]

Why would you want to create a macro that is attached to a button for asscending sort? You have this capability on the data tab sort button or hilight the selection right click and you will see sort.

 

[Wayne H]

This is a sheet used by other people and not all can use computers very well, this is to minimise their input.

 

[mos]

Make some data in cells.
Go Extras - Macros - Record
Do what should be done by the butt******* (mark cells, sort)
Stop recording.
Look in the code, you see this:

Sub Makro2()
    Range("D7:D11").Select
    Selection.Sort Key1:=Range("D7"), Order1:=xlDescending, Header:=xlGuess, _
        OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
        DataOption1:=xlSortNormal
End Sub

now modify the Range you want to have sorted, can include empty cells.


Add a Button via controlelements - toolbox

Connect the Makro2 to the Button.

 

[Wayne H]

Thanks MOS