action on cell activate
 

How do I get a cell to perform an action (fill in a value) upon selection

action on cell activate
 

Right click on the sheet tab you wnat to add the action to. Select View Code.
Aboce the code window you will see a drop down with the word general in it.
Change it to worksheet. When you do this a procedure will be added to the
code window. This is the selection change event. Whenever the user moves
around on this sheet this code will execute. There is a Target, which is the
cell that was just selected. You can use this the same as you would the
active cell.
--
HTH...

Jim Thomlinson


"KimR.Hammel" wrote:

How do I get a cell to perform an action (fill in a value) upon selection