Excel / VB experts

Discussion in 'OT Technology' started by Moistfly, May 21, 2004.

  1. Moistfly

    Moistfly Anal Bum Cover

    Joined:
    Oct 19, 2001
    Messages:
    12,434
    Likes Received:
    0
    Location:
    Texas
    I'm trying to create a button at the top of certain columns that will drop down a menu and allow you to sort ascending or descending. I have the feature on a few other worksheets but the code for it is protected for some reason :ugh: Anyway, I just need some kind of starting point, even an online tutorial would be great if someone could point me in the right direction.
     
  2. Moistfly

    Moistfly Anal Bum Cover

    Joined:
    Oct 19, 2001
    Messages:
    12,434
    Likes Received:
    0
    Location:
    Texas
    OK, I'm narrowing this down by going through basic tutorials but now I have a specific question, how do I code the sort button?

    Private Sub CommandButton1_Click()
    Label1.Click = sortascending(a3:a53)

    End Sub

    Obviously this isn't correct but hopefully it gives someone an idea of what i'm trying to do :o

    I hate being teh newb :(
     

Share This Page