+ Reply to Thread
Results 1 to 11 of 11

Accelerator Key to a command button with caption having multi character

  1. #1
    Registered User
    Join Date
    03-03-2011
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    8

    Red face Accelerator Key to a command button with caption having multi character

    I want to give a Accelerator Key to a Command button, whose caption is set as "Cancel".
    On setting the Accelerator Key as "C" it doesn't display it, might be due to repetition of the character c.

    How to set Accelerator Key where caption contains same characters for which the key needs to be set
    Last edited by getsunils; 03-15-2011 at 01:04 AM. Reason: Solved_Accelerator Key

  2. #2
    Forum Expert
    Join Date
    11-23-2005
    Location
    Rome
    MS-Off Ver
    Ms Office 2016
    Posts
    1,628

    Re: Accelerator Key to a command button with caption having multi character

    I think your problem is not caused by the double letter, but from the abbreviations Excel has in menu bar.

    Regards,
    Antonio

  3. #3
    Forum Expert
    Join Date
    11-23-2005
    Location
    Rome
    MS-Off Ver
    Ms Office 2016
    Posts
    1,628

    Re: Accelerator Key to a command button with caption having multi character

    In my previous post I probably have misunderstood the question.

    Did you ty to use the letter 'C' and 'c', upper and lower case?

    Regards,
    Antonio

  4. #4
    Registered User
    Join Date
    03-03-2011
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Accelerator Key to a command button with caption having multi character

    Quote Originally Posted by antoka05 View Post
    In my previous post I probably have misunderstood the question.

    Did you ty to use the letter 'C' and 'c', upper and lower case?

    Regards,
    Antonio
    I tried to use the only letter C in the Accelerator propery of Command button

    Regards
    Sunil

  5. #5
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,482

    Re: Accelerator Key to a command button with caption having multi character

    Post example workbook to demonstrate this problem.
    Cheers
    Andy
    www.andypope.info

  6. #6
    Registered User
    Join Date
    03-03-2011
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Accelerator Key to a command button with caption having multi character

    Quote Originally Posted by Andy Pope View Post
    Post example workbook to demonstrate this problem.
    Added the example wb.

    I have created 2 forms userform 1 & 2 with Cancel button in both the form. After giving the Accelerator for all the command button only for User form 1 i am able to see the output of Accelerator
    Attached Files Attached Files

  7. #7
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,482

    Re: Accelerator Key to a command button with caption having multi character

    The buttons on userform2 are not tall enough to display the underline.

    Either increase the height or reduce the font size.

  8. #8
    Registered User
    Join Date
    03-16-2009
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    97

    Re: Accelerator Key to a command button with caption having multi character

    heres one way of doing it.

    Please Login or Register  to view this content.

  9. #9
    Registered User
    Join Date
    03-16-2009
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    97

    Re: Accelerator Key to a command button with caption having multi character

    Take that back sorry only works when focus set to command button.

  10. #10
    Registered User
    Join Date
    03-03-2011
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Accelerator Key to a command button with caption having multi character

    Quote Originally Posted by radar_jynx View Post
    Take that back sorry only works when focus set to command button.
    Thanks for d help, closing the thread

  11. #11
    Registered User
    Join Date
    03-03-2011
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    8

    Same Action for Multiple Command Button Click event

    closing the thread
    Last edited by getsunils; 03-15-2011 at 01:37 AM. Reason: new thrd

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1