Forum

Hi Miguel, Yes now I understand! Its the Sheet module that I had to use Public Sub runCountDown() ' SHEET COMMANDBUTTON If IsNumeric(...

Thanks Miguel, I have added Option Explicit 'Public Const sCount As Long = 60 ' seconds Public Const sCount As Long = Folha1.Range("A2"...

Thanks Miguel, This works perfectly! There is one thing. Because I made UserName and passcode login....Who-ever is logged on there is a time all...

Thanks Miguel, So this means I need to redesign my time allocation? Also does this mean the code in Userform 1 below, Do I need to put after End...

Hi Miguel, You are right its not easy but I do have vaious errors simply because of the structure of my database and very long modules and codes. -...

Yes sorry Migel, I'm coming back to work tomorrow sydney time as I am on holidays for 4 days. Your explanation is something that I am interested in re...

Hi Phil. I found the reason why the code below is debugging. Application.OnTime Now + TimeValue("00:00:01"), "Nexttick", , False When I ...

Hi Phil, I tried 365 and there still a debug. However, I have an alternative. I have made an internal timer and it works well. So long as the pr...

Thanks Phil, Let me try tomorrow on my work computer 365 see if it works I have sneaky suspicion that on some occasions, some codes just don't...

Hi Phil, Thanks for that now its debugging method on Application.Ontime in stoptimer???.Please see attached JPG Application.OnTime Now + Ti...

The Value In Sheet1.RangeA2 is just a custom format hh:mm:ss----its just a timer But for some reason its highlighting VBA in SUb Next_Moment() ...

Hi Purfleet, There is more questions to be raised! But in saying that, Yes, I am thinking of having a Sub step below the selection. There no...