Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: How to rename a forms button

  1. #1
    Join Date
    19th January 2011
    Posts
    3

    How to rename a forms button

    I'm trying to rename a forms button (not a command button) I don't mean the caption, but the name of the button itself.
    Needing
    APP = Application.Caller
    to grab the name of what button is pushed. Commandbuttons won't do it. Need this so I can use the same code of each button.

    Thanks,
    Jim

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    12th September 2006
    Location
    The Great State of Texas
    Posts
    4,322

    Re: How to rename a forms button

    Perhaps
    VB:
    ActiveSheet.Shapes(Application.Caller).Name = "Bob" 
    
    
    Entia non sunt multiplicanda sine necessitate.
    MS MVP - Excel

  3. #3
    Join Date
    19th January 2011
    Posts
    3

    Re: How to rename a forms button

    I looked every where. Was thinking it couldn't be done. I seen two others asking the same question but they didn't get a correct answer. Mostly telling them how to change the caption. But not here. Thanks. This works just great. What a great site.

    Jim.

    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. Replies: 3
    Last Post: October 30th, 2010, 04:08
  2. Rename Command Button
    By trichard0987 in forum EXCEL HELP
    Replies: 15
    Last Post: March 18th, 2008, 11:10
  3. Rename Custom Toolbar Button
    By RowanS in forum EXCEL HELP
    Replies: 2
    Last Post: April 20th, 2007, 18:37
  4. Button In The Sheet To Run Forms
    By Tara01 in forum EXCEL HELP
    Replies: 4
    Last Post: March 20th, 2007, 16:16
  5. Click button to rename sheet tabs based on range
    By sweather in forum EXCEL HELP
    Replies: 24
    Last Post: August 16th, 2006, 07:35

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