Results 1 to 9 of 9
  1. #1
    2 Star Lounger
    Join Date
    Jan 2007
    Posts
    123
    Thanks
    13
    Thanked 1 Time in 1 Post

    Newbie needs VBA tweak: icons to text buttons (Excel 2002)

    I am very new to VBA. I

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Newbie needs VBA tweak: icons to text buttons (Excel 2002)

    Welcome to Woody's Lounge!

    I have attached a simple demo.
    The basic code is in the module Module1.
    The ThisWorkbook module contains event handlers that call code from Module1 to create, delete, show and hide the custom toolbar.

    Feel free to post a reply in this thread if you have questions about the code.

  3. #3
    2 Star Lounger
    Join Date
    Jan 2007
    Posts
    123
    Thanks
    13
    Thanked 1 Time in 1 Post

    Re: Newbie needs VBA tweak: icons to text buttons (Excel 2002)

    Amazing -- someone who knows a) VBA and [img]/forums/images/smilies/cool.gif[/img] how to explain to a non-techie.

    I was able to adapt it in 1 minute. Now I am POWERFUL! Thanks so much. I will ask Woody to give you a raise.

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Newbie needs VBA tweak: icons to text buttons (Excel 2002)

    Which proves that it is not how you ask, but where (who) you ask. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    Woody doubles Hans' salary every day!
    Legare Coleman

  5. #5
    2 Star Lounger
    Join Date
    Jan 2007
    Posts
    123
    Thanks
    13
    Thanked 1 Time in 1 Post

    Re: Newbie needs VBA tweak: icons to text buttons (Excel 2002)

    Wow, maybe I should work for Woody .... in a few weeks I'd be making minimum wage!

    Thanks again. Did I mention I love the Dutch?

  6. #6
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Newbie needs VBA tweak: icons to text buttons (Excel 2002)

    It depends on your starting salary, which is $0.00 here in the Lounge. <img src=/S/yep.gif border=0 alt=yep width=15 height=15>
    Legare Coleman

  7. #7
    2 Star Lounger
    Join Date
    Jan 2007
    Posts
    123
    Thanks
    13
    Thanked 1 Time in 1 Post

    Re: Newbie needs VBA tweak: icons to text buttons (Excel 2002)

    Hmmm, that's different.

    But, then again....well.... maybe, if you double it lots and lots, REAL FAST.... <img src=/S/crossfingers.gif border=0 alt=crossfingers width=17 height=16>

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Newbie needs VBA tweak: icons to text buttons (Excel 2002)

    Hmm, after almost 5 years, it's still a very round figure...

  9. #9
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Newbie needs VBA tweak: icons to text buttons (Excel 2002)

    You'll soon discover that here in the Lounge, Hans (and others) will provide not only a) and [img]/forums/images/smilies/cool.gif[/img] but also the c) -> z) optional extras in record time. <img src=/S/grin.gif border=0 alt=grin width=15 height=15> Well... that's the theory anyway - but as another great philosopher once said:

    You can't always get what you want
    But if you try sometimes you just might find
    You get what you need


    Alan

Posting Permissions

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