right click sheet tab>view code>copy/paste this>Save
Now when you select cell a5 the number will increment by 1. Use 0 to show
only 1.
You could also use a right click or double click event instead.
Private Sub Worksheet_selectionChange(ByVal Target As Range)
If Target.Address = "$A$5" Then Target = Target + 1
End Sub
Don Guillett
SalesAid Software
[EMAIL PROTECTED]
----- Original Message -----
From: "Slattery, Tim - BLS" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Friday, April 14, 2006 1:42 PM
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]
--
----------------------------------------
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
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.385 / Virus Database: 268.4.1/311 - Release Date: 4/13/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
