Thread: Worksheet_Change Event triggered off specific cell
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
mudraker[_253_] mudraker[_253_] is offline
external usenet poster
  
Posts: 1
Default Worksheet_Change Event triggered off specific cell
ExcelMonkey

You can not have it trigger off a particular cell.

You need to test the target.address


if target.address ="$A$1" then
do something
end if

also look at using Intersect to test your targe

--
Message posted from http://www.ExcelForum.com

Reply With QuoteReply With Quote