Thread: Timer
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Paul Lautman Paul Lautman is offline
external usenet poster
 
Posts: 85
Default Timer

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