Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.excel.programming > #109500

Re: Watchdog timer issues

Show all headers | View raw

In message <nv35ig$sla$1@dont-email.me> of Sat, 29 Oct 2016 17:50:33 in
microsoft.public.excel.programming, GS <gs@v.invalid> writes
Gary,
Thanks for your input.

>Walter,
>
>Try...
>
> Private Const vKillET = "00:00:30"

That is effectively what I do in
>Private Const killduration As String = "00:00:30"
I don't do Magyar. ;)

I feel I should be able to do
Private Const vKillET as date = sommething.

>
>..and in your function...
>
> killtime = TimeValue(Now) + TimeValue(vKill_ET)
> 'returns time in hh:mm:ss AM/PM

I do that partially with
>    killtime = now + TimeValue(killduration)

Why would you "cast" now?
?typename(now)
Date
?typename(timevalue(now))
Date

>
>Also, in your function you might want to def a var to hold the boolean
>value used in your If..Then block. It can be set True as a default
>unless a condition toggles it false...
>
> Dim bMyVar As Boolean
> bMyVar = True '//assume success
>
> '//some code that preserves or toggles bMyVar
>
> If Not bMyVar Then
>newie:
> ...
>

I must concede I am overloading killtime as both a value and a flag.
Slightly insanitary. ;)

How do I turn green cell north west corners into text?
-- 
Walter Briscoe

Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Watchdog timer issues Walter Briscoe <wbriscoe@nospam.demon.co.uk> - 2016-10-29 14:59 +0100
  Re: Watchdog timer issues GS <gs@v.invalid> - 2016-10-29 17:50 -0400
    Re: Watchdog timer issues Walter Briscoe <wbriscoe@nospam.demon.co.uk> - 2016-10-30 20:34 +0000
  Re: Watchdog timer issues GS <gs@v.invalid> - 2016-10-29 17:52 -0400
    Re: Watchdog timer issues Walter Briscoe <wbriscoe@nospam.demon.co.uk> - 2016-10-30 20:38 +0000
      Re: Watchdog timer issues GS <gs@v.invalid> - 2016-10-30 17:14 -0400
        Re: Watchdog timer issues GS <gs@v.invalid> - 2016-10-30 17:36 -0400
          Re: Watchdog timer issues Walter Briscoe <wbriscoe@nospam.demon.co.uk> - 2016-11-02 09:43 +0000
            Re: Watchdog timer issues GS <gs@v.invalid> - 2016-11-02 13:30 -0400
              Re: Watchdog timer issues Adrian Caspersz <email@here.invalid> - 2016-11-03 17:44 +0000
                Re: Watchdog timer issues GS <gs@v.invalid> - 2016-11-03 15:33 -0400
                Re: Watchdog timer issues Adrian Caspersz <email@here.invalid> - 2016-11-03 20:11 +0000
                Re: Watchdog timer issues GS <gs@v.invalid> - 2016-11-03 16:47 -0400
                Re: Watchdog timer issues Walter Briscoe <wbriscoe@nospam.demon.co.uk> - 2016-11-06 10:37 +0000
              Re: Watchdog timer issues Walter Briscoe <wbriscoe@nospam.demon.co.uk> - 2016-11-06 11:42 +0000
                Re: Watchdog timer issues GS <gs@v.invalid> - 2016-11-07 12:18 -0500
  Re: Watchdog timer issues Tqlebvng514 <Thlebkng152@gmail.com> - 2016-10-30 06:03 +0000
  Re: Watchdog timer issues Tqlebvng514 <Thlebkng152@gmail.com> - 2016-10-30 07:03 +0000
  Re: Watchdog timer issues Tqlebvng514 <Thlebkng152@gmail.com> - 2016-10-30 08:03 +0000
  Re: Watchdog timer issues Tqlebvng514 <Thlebkng152@gmail.com> - 2016-10-30 11:04 +0000
  Re: Watchdog timer issues Tqlebvng514 <Thlebkng152@gmail.com> - 2016-10-30 13:04 +0000
  Re: Watchdog timer issues Tqlebvng514 <Thlebkng152@gmail.com> - 2016-10-30 14:03 +0000
  Re: Watchdog timer issues Tqlebvng514 <Thlebkng152@gmail.com> - 2016-10-30 15:03 +0000
  Re: Watchdog timer issues Tqlebvng514 <Thlebkng152@gmail.com> - 2016-10-30 16:03 +0000
  Re: Watchdog timer issues giaxeoto4banh <giaxeoto4banh@gmail.com> - 2016-11-03 12:19 +0000
  Re: Watchdog timer issues tinhdauhcm1 <tinhdauhcm1@gmail.com> - 2016-11-03 16:01 +0000
  Re: Watchdog timer issues dailycuacuonhcm <dailycuacuonhcm@gmail.com> - 2016-11-04 01:52 +0000

csiph-web