Sort button
Sort button
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Sort button

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    28
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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

  2. #2
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.



  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    28
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  4. #4
    New Member
    Join Date
    Mar 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    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.


User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com