Posts by EJohn

    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) ....


    Code
    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