Sort button

daveray · Mar 17th, 2002, 03:29 AM

Can someone tell me how I can insert a simple button using VBA that will sort sales figures in ascending order. I have written a simple macro that works but rather than using CTL + S I thought it would look better if there was a command button.

All help gratefully received.

Dave

Dave Hawley · Mar 17th, 2002, 03:48 AM

Hi Dave

There are many ways this can be done. But you would probably want it as part of the Workbook only so try this.

Right click on any menu item and select "Forms". Then from this toolbar click on the CommandButton, then simply click on your Sheet. The "Macro" dialog will automatically display so just select your macro name and click OK.

daveray · Mar 17th, 2002, 04:50 AM

Thanks for that, it worked just how I wanted it. It never ceases to amaze me just how simple this can be when someone can point you in the right direction.

Dave

Osric · Mar 17th, 2002, 07:48 AM

Quote:

On 2002-03-17 03:50, daveray wrote:
Thanks for that, it worked just how I wanted it. It never ceases to amaze me just how simple this can be when someone can point you in the right direction.

Dave

It's also amazing how Excel has a Help file that does exactly that.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 17th, 2002, 03:29 AM	#1
daveray New Member Join Date: Mar 2002 Posts: 28	Can someone tell me how I can insert a simple button using VBA that will sort sales figures in ascending order. I have written a simple macro that works but rather than using CTL + S I thought it would look better if there was a command button. All help gratefully received. Dave

Mar 17th, 2002, 03:48 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi Dave There are many ways this can be done. But you would probably want it as part of the Workbook only so try this. Right click on any menu item and select "Forms". Then from this toolbar click on the CommandButton, then simply click on your Sheet. The "Macro" dialog will automatically display so just select your macro name and click OK.

Mar 17th, 2002, 04:50 AM	#3
daveray New Member Join Date: Mar 2002 Posts: 28	Thanks for that, it worked just how I wanted it. It never ceases to amaze me just how simple this can be when someone can point you in the right direction. Dave