Search:

Type: Posts; User: bearded_oneder

Search: Search took 0.04 seconds.

  1. Replies
    15
    Views
    17,918

    Re: Square Root

    Errata 3: To improve efficiency, inserted Exit Function at line 23. This avoids processing the statements after the ErrHandler: label each time the function is called, even when no error has occurred.
  2. Replies
    15
    Views
    17,918

    Re: Square Root

    Errata 2: Declared data type for sErrPrompt on line 10,


    Dim sErrPrompt As String
  3. Replies
    15
    Views
    17,918

    Re: Square Root

    Errata:
    :ehh: OOPS! Turning Option Explicit on revealed a Variable not defined error on line 27, caused by an incomplete variable name on line 26. Lines 24 - 30 debugged,


    ErrHandler:
    If...
  4. Replies
    15
    Views
    17,918

    Re: Square Root

    Since this post is two years old, I'll assume that SlicedCheese has either completed his homework or failed. Some suggestions:

    Your Function SquareRoot() will default to the Variant data type,...
Results 1 to 4 of 4



Click Here to Expand Forum to Full Width