Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do I make a counter cell in excel
Can some one help me in telling me how can I do a counter in the excel which
will increase the number by 1 every time I press F9. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do I make a counter cell in excel
Hi,
There may be a neater way to do this, but worth trying; In the sheets code module add; Private lMyCounter As Long Public Property Get MyCounter() As Long MyCounter = lMyCounter End Property Public Property Let MyCounter(lNewValue As Long) lMyCounter = lNewValue End Property In a 'normal' module add; Public Function ShowMyCounter(dTrigger As Date) As Long Sheet1.MyCounter = Sheet1.MyCounter + 1 xMyCounter = Sheet1.MyCounter End Function In the sheet you can now reference the formula; =ShowMyCounter(NOW()) The 'trigger' is required to make the thing recalc when you hit f9. Regards, Chris. -- Chris Marlow MCSD.NET, Microsoft Office XP Master "Ehab Hassan" wrote: Can some one help me in telling me how can I do a counter in the excel which will increase the number by 1 every time I press F9. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do I make a counter cell in excel
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I set up a counter cell? | Excel Worksheet Functions | |||
dynamic character counter for merged cell text field | Excel Worksheet Functions | |||
Cell counter | Excel Discussion (Misc queries) | |||
How do I set up a counter in excel? | Setting up and Configuration of Excel | |||
Make counter invisible | Excel Programming |