Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: Change Button Caption Code

  1. #1
    Join Date
    20th July 2007
    Posts
    4

    Change Button Caption Code

    Split off from: http://www.ozgrid.com/forum/showthread.php?t=73924

    That's great the
    VB:
    Sheets("Name").Shapes("objName").ControlFormat.Enabled=False 
    
    
    works brilliantly.

    However, using that method, I can't alter the Caption of the buttons, any idea of a way to do this?

    Thanks
    James
    Last edited by Dave Hawley; July 31st, 2007 at 19:07.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,717

    Re: Change Button Caption Code

    James, please use code tags for any code and always start a New Thread when your question no longer matches the Thread Title. I have done both for you, but please take more care and read the text you are shown when posting.

    VB:
    Sheet1.Shapes("Button 1").TextFrame.Characters.Text = "Click Me!" 
    
    

  3. #3
    Join Date
    14th July 2004
    Posts
    10,539

    Re: Change Button Caption Code

    Another approach.
    VB:
    Set o = Worksheets("Sheet1").Shapes("Button 1") 
    o.OLEFormat.Object.Caption = "New Caption" 
    
    
    Boo!

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Change Button Shape Caption
    By ecawilkinson in forum EXCEL HELP
    Replies: 4
    Last Post: January 9th, 2013, 00:12
  2. Change Toggle Button Caption On 2007 Ribbon
    By tparente in forum EXCEL HELP
    Replies: 2
    Last Post: July 2nd, 2008, 11:26
  3. Replies: 2
    Last Post: January 11th, 2008, 17:40
  4. Change Caption Property Of Option Button
    By mfsuk in forum EXCEL HELP
    Replies: 8
    Last Post: March 24th, 2007, 01:35
  5. Toggle change control button face id & caption
    By mikeburg in forum EXCEL HELP
    Replies: 2
    Last Post: June 27th, 2005, 01:53

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