CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. April 12th, 2001, 03:52 AM #1
    Akademos
    Akademos is offline Member
    Join Date
    Mar 2000
    Location
    Germany, Franken
    Posts
    257

    Excel/VBA Connect a Button with an Shortcut

    Hi,
    here's a easy question for the most of you ;-). I add a Button in a Excelsheet. How to i connect this with a key shortcut? I tried to do it the same way as in VB (add a '&' *n the caption property) but it didn't work. can anyone help me please

    thanks

    akademos

    Reply With Quote Reply With Quote
  2. April 12th, 2001, 09:46 AM #2
    coolbiz's Avatar
    coolbiz
    coolbiz is offline Elite Member
    Join Date
    Feb 2001
    Location
    Stamford CT USA
    Posts
    2,167

    Re: Excel/VBA Connect a Button with an Shortcut

    Right click on the button and choose PROPERTIES from the POPUP MENU.

    If the caption on the button is "SHUTDOWN" and you want ATL+S to activate it, then set the ACCELERATOR property to S.

    -Cool Bizs

    Good Luck,
    -Cool Bizs
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules




Click Here to Expand Forum to Full Width

Featured