+ Reply to Thread
Results 1 to 5 of 5

Errorcode 91: Can't find my mistake

  1. #1
    Registered User
    Join Date
    09-27-2012
    Location
    london
    MS-Off Ver
    Excel 2007
    Posts
    3

    Exclamation Errorcode 91: Can't find my mistake

    Hi guys!

    I've tried to write a code for a stopwatch.
    I used the code from http://www.vbaexpress.com/kb/getarticle.php?kb_id=242 and it worked fine.
    Then I've edited the code to start and stop it with commandbuttons. That's were my mistake must happend but although I've spent hours of work on it I still can't find it.
    Here is my edited code:
    Please Login or Register  to view this content.
    Thanks flo.111

  2. #2
    Forum Contributor
    Join Date
    06-09-2011
    Location
    Germany
    MS-Off Ver
    Excel 2016
    Posts
    194

    Re: Errorcode 91: Can't find my mistake

    Hi,

    since your variable a dimensioned as a range and not as a value, you need to set it in both your startit and stopit macros. This means rather than putting
    Please Login or Register  to view this content.
    it should be
    Please Login or Register  to view this content.
    Regards

    Theo
    Remember To Do the Following....
    1. Upload sample files
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.

  3. #3
    Registered User
    Join Date
    09-27-2012
    Location
    london
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Errorcode 91: Can't find my mistake

    Thanks for your quick reply!
    The error is gone now but I still can't use the code with commandbuttons.
    I hope somebody can find the reason.

    Another thanks
    flo.111

  4. #4
    Forum Contributor
    Join Date
    06-09-2011
    Location
    Germany
    MS-Off Ver
    Excel 2016
    Posts
    194

    Re: Errorcode 91: Can't find my mistake

    Hi,
    we are pretty much misussing the macro - but after some tweaking it works:
    Please Login or Register  to view this content.
    Of cause there is no button for leap time but start stop should work

    Regards

    Theo

  5. #5
    Registered User
    Join Date
    09-27-2012
    Location
    london
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Errorcode 91: Can't find my mistake

    Thank you so much!!!
    It now works very fine.

    Thanks, thanks, thanks
    flo.111

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1