Overflow error in VBA. RRS feed

  • Question

  • I have an structure in VBA. Trying to assign a value in the structured variable, while assigning a value getting the overflow error. Following is the code.

    Type typeRXTestParameters
        RSBGain_PRX_Correction As Double
        RSBPhase_PRX_Correction As Double
        RSBGain_DRX_Correction As Double
        RSBPhase_DRX_Correction As Double
        RSBGain_Correction As Double
        RSBPhase_Correction As Double
        IQ_PRX As String
        IQ_DRX As String
    End Type

    Global g_RXTestParameters As typeRXTestParameters

    public sub sample()

     g_RXTestParameters.RSBGain_PRX_Correction = 0.22 ' assigning the value & getting the overflow error

    end sub,

    This problem is not appearing always. If i keep on executing the above code then only i'm getting this error. If i debug the code also not getting the overflow error.

    Please let me know the solution for this. Thanks in advance

    • Edited by Ramakrishna123 Monday, July 23, 2012 11:01 AM
    • Moved by Reed KimbleMVP Monday, July 23, 2012 7:01 PM vba in vb language (From:Visual Basic Language)
    Monday, July 23, 2012 10:44 AM

All replies