+ Reply to Thread
Results 1 to 4 of 4

UserForm Command Button - how to make it change appearance when clicked

  1. #1
    Registered User
    Join Date
    01-05-2012
    Location
    Salinas
    MS-Off Ver
    Excel 2007
    Posts
    22

    UserForm Command Button - how to make it change appearance when clicked

    I have a very basic question, and know I must be just missing something... but I have a userform with some command buttons. I would like the command button to appear depressed when you click on it... I can't figure out how to do that from looking at the Properties tab.. any help would be appreciated!

    Thank you.

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: UserForm Command Button - how to make it change appearance when clicked

    Hi,

    Unlike say a ListBox which does have a 'Sunken' property, the CommandButton doesn't.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    01-05-2012
    Location
    Salinas
    MS-Off Ver
    Excel 2007
    Posts
    22

    Re: UserForm Command Button - how to make it change appearance when clicked

    Thank you for your help

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

    Re: UserForm Command Button - how to make it change appearance when clicked

    A command button on a userform should show as depressed when you mouse down ( or press the space bar) but it will then rise again on Mouse up.

    If you want the button to remain depressed you need to use the Toggle Button control.
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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