Results 1 to 5 of 5
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Access Key on Form Button (Excel 2003)

    Hi

    Iam trying to add an access key to a caption on a cmdButton on a userform, I tried &Service to get the S underlined for the use of Alt-S.
    But it appears as &Service and not with the S underlined. Any Ideas please.

    Many Thanks

    Braddy
    If you are a fool at forty, you will always be a fool

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

    Re: Access Key on Form Button (Excel 2003)

    Set the Caption property to Service and the Accelerator property to S.

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Access Key on Form Button (Excel 2003)

    Hi Hans

    Thanks for the swift reply, whilst your offering works fine it doesn't place and underscore under the S in Service.


    Thanks

    Braddy
    If you are a fool at forty, you will always be a fool

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Access Key on Form Button (Excel 2003)

    Adding an "S" as the accelarator key works in my tests to underscore the accelerator letter in the caption

    Steve

  5. #5
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Access Key on Form Button (Excel 2003)

    Hi Steve

    Your quite right it does work, It was a case of my buttons were too small or the text was too large for the button, on enlarging my buttons it was plain to see.

    Many thanks to you and Hans for your kind assistance.

    Braddy
    If you are a fool at forty, you will always be a fool

Posting Permissions

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