calling a macro upon selecting a cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

when i select a cell, say B2, a message box comes up with a message i wrote
in a macro at some point in the past. it asks if i want to proceed w/ the
subroutine. for the life of me, i cannot figure out how to get to this code.
it does not appear to be in vbe, at least not under modules (there are non
in this spreadsheet). how do you call a sub by simply selecting a cell and
where is the code stored? thanks, mike allen
 
Right click on the sheet tab of the sheet the cell is in. Then click View
Code.
It sounds like a worksheet_change macro.
 
perfect! i would have never found it, even though i have obviously used it
before. thank you.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
Code for multiple select of cells 16
Run Macro Upon Entering Data into Cell/s 3
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
populate cells using select case 3
When something in module is shown as a macro 3
Call Macro 3
Make a maro run upon leaving a cell 0

Back
Top