Object required error when using variable in sub formula

  • Greetings!

    I'm at my wits end with this one...

    I'm passing a value entered from a textbox on my Excel sheet (see code below) ....

    Public Sub TextBox1_Change()
    Dim DaysToCompletion As Integer
    DaysToCompletion = TextBox1.Value
    Call v_GetDaysToCompletion(DaysToCompletion) (Calls sub routine)
    End Sub

    So I'm passing the value to from "DaysToCompletion" this sub routine below and I'm trying to use the value stored in the variable in the formula below to be placed in cell "D19". However, I'm getting an error when the program hits the formula where I'm trying to subtract cell A19 from cell B19 and add the value of the variable "DaysToCompletion"..

    Any help will be greatly appreciated

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!