Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If ActiveCell.Address = "$C$3" Then
[c3].Value = [c3].Value + 1
End If
End Sub
MF
-----Original Message-----
From: Windows Home/SOHO [mailto:[EMAIL PROTECTED] On Behalf
Of Slattery, Tim - BLS
Sent: Friday, 14 April, 2006 15:43
To: [email protected]
Subject: APPS: onClick for cell in Excel
I suppose I should be asking this on the Excel list, but I'm not
subscribed there. Is there a way to associate a macro with a click on a
cell in Excel, like an onClick attribute in HTML?
I'm trying to get a cell to increment when I click on it, and I can't
see how to do it.
--
Tim Slattery
[EMAIL PROTECTED]
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.385 / Virus Database: 268.4.1/311 - Release Date:
13/04/2006
--
----------------------------------------
WIN-HOME Archives: http://PEACH.EASE.LSOFT.COM/archives/WIN-HOME.html
Contact the List Owner about anything: [EMAIL PROTECTED]
Official Win-Home List Members Profiles Page
http://www.besteffort.com/winhome/Profiles.html