Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 4 of 4

Thread: Command Button Properties

  1. #1
    Join Date
    22nd July 2004
    Posts
    2

    Command Button Properties

    I am trying to change the "look" of a command button but for some reason when I right click it, the properties selection is not available. Any suggestions on what I may or may not be doing to cause this?

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    26th January 2003
    Location
    UK
    Posts
    4,682
    There are two types of command button as such on offer
    1 – Forms button
    2 – Toolbox Command Button

    Both do the same job that’s is execute code on command [click] just toolbox command buttons are a bit more powerful in what they have to offer

    Referring back to your question, you can use either button in excel, you will need to link the code of cause to that button, Toolbox command buttons default to ….._Click() this is as they are widely used in projects / user forms where that information is critical.

    You can not custom Forms Command Buttons they are as is, bar the text. Toolbox buttons can be custom this is in the VBE [Visual Basic Editor} press alt+F11 together to bring this application into session.

    Here you need to select the button and custom in VBE, colour and so on, lots of bits can e done, have a try.

    Also for easy try right click the bottom | Assign Macro | and select edit

    This is a alternative way to bring the VBE to that button and can custom in the VBE_Properties windows and so on.

    Hope that guides you a bit more, post back if you need more

    Jack

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    22nd July 2004
    Posts
    2
    THANK YOU!!! That absolutely answered my problem. I had a forms button instead of using a control command button. I changed over to the control command button and was able to "color" change it.

    Thanks again and greetings from Philadelphia, PA.

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    26th January 2003
    Location
    UK
    Posts
    4,682
    Greeting to buddy - have loads of fun .... thanks for letting me / us all know very kind

    Rdgs

    Jack

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Run Command Button Click From Another Command Button
    By ExcelJunkie in forum EXCEL HELP
    Replies: 11
    Last Post: January 1st, 2014, 23:02
  2. Replies: 2
    Last Post: April 25th, 2007, 23:12
  3. Replies: 6
    Last Post: January 13th, 2006, 18:11
  4. Command Button Properties
    By txaggie in forum EXCEL HELP
    Replies: 6
    Last Post: September 20th, 2005, 00:05
  5. Replies: 3
    Last Post: August 23rd, 2005, 15:29

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
  •  
porno