Determine text in button and use it in code

**marrott2** · 05-01-2013, 01:44 PM

I want to have one sub() that runs when any button is pressed. The sub should determine what the text of the button is and do an if then statement for different code depending on the text of the button pressed.
Any one have any ideas how to tackle this?

**tigeravatar** · 05-01-2013, 01:50 PM

marrott2,

At its most basic, and assuming that you are using form control buttons on a worksheet:

Please Login or Register  to view this content.

**marrott2** · 05-01-2013, 02:05 PM

Works like a charm. Thanks for the quick response!

**tigeravatar** · 05-01-2013, 02:08 PM

You're very welcome

Determine text in button and use it in code

LinkBack

Thread Tools

Rate This Thread

Display

Determine text in button and use it in code

Re: Determine text in button and use it in code

Re: Determine text in button and use it in code

Re: Determine text in button and use it in code

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions