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

R

Rosie

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

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
 
Top