pedie
Well-known Member
- Joined
- Apr 28, 2010
- Messages
- 3,875
As I check the Object Brower by pressing Alt+f11 - "CDbl" is a VBA Member of conversion...
Please explain what does "CDbl(Time)" does in the macro below?
I have also seen Cdate, CVdate, Cdec etc...is there a website i can learn what all this function means ....but please explain to me this works..
ThisWorkbook.Sheets("Myexcel").Range("MyClock").Value = CDbl(Time)<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
NextTick = Now + TimeValue("01:00:00")<o></o>
Application.OnTime NextTick, "Updateclok"
"Many thanks everyone!!!!"
Please explain what does "CDbl(Time)" does in the macro below?
I have also seen Cdate, CVdate, Cdec etc...is there a website i can learn what all this function means ....but please explain to me this works..
ThisWorkbook.Sheets("Myexcel").Range("MyClock").Value = CDbl(Time)<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
NextTick = Now + TimeValue("01:00:00")<o></o>
Application.OnTime NextTick, "Updateclok"
"Many thanks everyone!!!!"