Hi all
I need to find a function that lets me update the data quickly and easily
for counting the number of phone calls visitors that come in to the centre.
eg a tally function or add one per click of the mouse type thing. Any
ideas?????
please help im going nuts and bannanas over this.
thanks rosie
--
sometimes its good to just have a coffe and a book for company

Hi Rosie,

Check out Spinners or put this in the sheet modual and assign to a button
from the Forms tool bar.

Sub TeleCounter()
Range("F1").Value = Range("F1").Value + 1
End Sub

HTH
Regards,
Howard

"Rosie" wrote in message
...
Hi all
I need to find a function that lets me update the data quickly and easily
for counting the number of phone calls visitors that come in to the
centre.
eg a tally function or add one per click of the mouse type thing. Any
ideas?????
please help im going nuts and bannanas over this.
thanks rosie
--
sometimes its good to just have a coffe and a book for company

Thank you thank you thank you thank you !!!! you are a life saver:D:D:D:D:D
--
sometimes its good to just have a coffe and a book for company


"L. Howard Kittle" wrote:

Hi Rosie,

Check out Spinners or put this in the sheet modual and assign to a button
from the Forms tool bar.

Sub TeleCounter()
Range("F1").Value = Range("F1").Value + 1
End Sub

HTH
Regards,
Howard

"Rosie" wrote in message
...
Hi all
I need to find a function that lets me update the data quickly and easily
for counting the number of phone calls visitors that come in to the
centre.
eg a tally function or add one per click of the mouse type thing. Any
ideas?????
please help im going nuts and bannanas over this.
thanks rosie
--
sometimes its good to just have a coffe and a book for company