Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Steve wrote:
Sorry Paul, should have explained. It's in a msgbox Cheers Just a quick question. I found how to doa timer by search on here which works really well. However, can't seem to format it so it only says "7 seconds" as opposed to "7.123456 seconds" Any help would be appreciated. Thanks -- Steve R OK we know where we are looking now! Somewhere in the VB script there will be the msgbox command and it will have as its first parameter either a variable or a calculation. Enclose this variable/calculation in the format function thus: MsgBox Format(22 / 7, "#") the above displays 3 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
TIMER | 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) | |||
Msg Box Timer | Excel Programming |