How can I trigger a macro from a specific active cell
ie. when i click into cell "A1" trigger the macro
How can I trigger a macro from a specific active cell
ie. when i click into cell "A1" trigger the macro
You will have to use the Selection Change Event in the Worksheet Module.
Right Click on the worksheet tab in question and select VIEW CODE
A module should pop up with two dropdown boxes at the top. Select WORKSHEET in the left dropdown, and SELECTION_CHANGE should appear in the second box by default. Now, in the code, you trigger the macro whenever cell A1 is selected.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks