Search results

Thanks for your time

Thanks Doc; It was an easy fix, I changed the Variant declaration to Double as you explained and pointed out , and it worked. I was just curious and very tired; Was not seeing well I appreciate your time. I usually work in Access where I have more control. It was a nice little exercise though :)

Thanks Doc So is there a work around ? Or do I have to start over?

Hello I don't have a form in Excel . That's why I was using input fields. I could use an excel form if I have a sample. or I can go back to access, but it is a long shot as my client uses excel. Thanks for your time

'Declarations Private Sub CommandButton2_Click() Dim inputValue As Double Dim unitType As String Dim result As Double Dim UserResponse As Long Dim nconntors As Double Dim nsplices As Double Dim ConnectLoss As Double Dim SpliceLoss As Double Dim MaxAttn As Double...