Using SelectionChange to run macros instead of Command Button

**Neuk** · 04-23-2018, 05:12 PM

Instead of using command buttons to run a macro, I did the following:

Please Login or Register  to view this content.

When I click on cell G12, the macro runs as expected, but A12 doesn't do anything... But when I hide G12 and only have A12 showing, it shows the userform as expected.

Why does it allow me to only do one at a time? Why can't I do both? Any help would be appreciated. Thanks.

**LeoTaxi** · 04-23-2018, 09:12 PM

because, if target.adress is not $G$12 there is a command to exit the sub

Please Login or Register  to view this content.

Kind regards
Leo

**Neuk** · 04-24-2018, 09:58 AM

Thanks for the sanity check, Leo...Let's forget I asked that

...

Using SelectionChange to run macros instead of Command Button

LinkBack

Thread Tools

Rate This Thread

Display

Using SelectionChange to run macros instead of Command Button

Re: Using SelectionChange to run macros instead of Command Button

Re: Using SelectionChange to run macros instead of Command Button

Thread Information

Users Browsing this Thread

Similar Threads

Click Command Button, run macros based on cell value

[SOLVED] One Command button for 2 macros( Not in the same time)

Can multiple macros be run with one command button

Assign two macros to a command button, but only one can automatically run!!

Assigning macros to a command button

Command button in an excel sheet to run all my macros

Creating Command Button macros

[SOLVED] Two Macros under One command button

Bookmarks

Bookmarks

Posting Permissions