View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
benb benb is offline
external usenet poster
 
Posts: 18
Default wait for user action in VBA code

Thank you.

"CBrine" wrote:


If Target.address ="$C$1" then

Your Code

End IF

If you need to do a range try

Dim R as range
Set R = Intersect(Target.address, Range("A:A"))

If R is not nothing then
Your Code
End If

HTH


--
CBrine


------------------------------------------------------------------------
CBrine's Profile: http://www.excelforum.com/member.php...o&userid=14705
View this thread: http://www.excelforum.com/showthread...hreadid=263234