Announcement

Collapse
No announcement yet.

How to rename a forms button

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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

  • #2
    Re: How to rename a forms button

    Perhaps
    Code:
    ActiveSheet.Shapes(Application.Caller).Name = "Bob"
    Entia non sunt multiplicanda sine necessitate.

    Comment


    • #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.

      Comment

      Working...
      X