Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Timer question
If I do Range ("a1") = timer on a loop then it refreshes showing fractions of a second, but shows whatever large number the timer is at However if i do tim = Timer Do diff = Timer - tim Range("a1") = diff loop then it counts up from zero, as intended, but for some reason drops all the decimal places Anyone know why it drops the decimals and how to make it keep the decimals? Many thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Timer question
Check your other post -- mikeaj72 ------------------------------------------------------------------------ mikeaj72's Profile: http://www.thecodecage.com/forumz/member.php?userid=46 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=44334 |
#3
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Timer question
tim and diff need to be declared as Single or Double. Integer and Long carry no decimal places. -- Jim Cone Portland, Oregon USA "teepee" wrote in message If I do Range ("a1") = timer on a loop then it refreshes showing fractions of a second, but shows whatever large number the timer is at However if i do tim = Timer Do diff = Timer - tim Range("a1") = diff loop then it counts up from zero, as intended, but for some reason drops all the decimal places Anyone know why it drops the decimals and how to make it keep the decimals? Many thanks |
#4
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Timer question
Thanks for the help
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
timer | Excel Discussion (Misc queries) | |||
Timer in VBA | Excel Discussion (Misc queries) | |||
Timer | Excel Discussion (Misc queries) | |||
Timer | Excel Worksheet Functions | |||
Stopping a Timer / Running a timer simultaneously on Excel | Excel Discussion (Misc queries) |