In Excel, run Code when cell selected.

[Wally0]

I want to run code when the user selects (moves on to) a cell in Excel. I have tried testing the active cell to determine if it matches my criteria (cell) but have not found the proper syntax. I know this must be simple... Please excuse my stumble. Any help in directing me to a helpful message thread or hints would be greatly appreciated.

Thanks, Wally

 

[RobBroekhuis]

I assume you've already figured out you need the Sheet_SelectionChange event. This event sub has a target parameter, which is a range. You can use a comparison such as

if target.address=range("MySpecialCell&quot.address then
..do code here
end if

Rob

 

[Wally0]

I tried your solution and get an error message "object required." I'm wrong somewhere in setting up the Target.address. Another hint? Thanks for your quick reply and assistance.

Wally

 

[Wally0]

It's working -- ignore the error. I tried to run my code from a sub routinue.