HELP!!!!!!!!!!!!please!!!!!!!!

[Guest]

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

 

[L. Howard Kittle]

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

 

[Guest]

Thank you thank you thank you thank you !!!! you are a life saver