Multiplying textboxes

[Schofi_D]

Hi All

I have 15 text boxes in my userform that i want to multiply by a corresponding text box and total in one text box

Example quantity is one text box (textbox37) and cost is the other textbox (textbox52) i want to multiply them two together but need to do this for all textboxes to get a total, i have tried the following, and belieiving thats the way to do it, it keeps returning an error, its early and maybe my brain hasnt woke up yet but waht am i missing? or what have i done wrong here?

TextBox63.Value = Format((TextBox48.Value * TextBox33.Value) + (TextBox49.Value * TextBox34.Value) + (TextBox50.Value * TextBox35.Value) + (TextBox51.Value * TextBox36.Value) + (TextBox52.Value * TextBox37.Value) + (TextBox53.Value * TextBox38.Value) + (TextBox54.Value * TextBox39.Value) + (TextBox55.Value * TextBox40.Value) + (TextBox56.Value * TextBox41.Value) + (TextBox57.Value * TextBox42.Value) + (TextBox58.Value * TextBox43.Value) + (TextBox59.Value * TextBox44.Value) + (TextBox60.Value * TextBox45.Value) + (TextBox61.Value * TextBox46.Value) + (TextBox62.Value * TextBox47.Value), "£###,###,##0.00")

Help is always appreciated

 

[Johnny C]

Your best bet is to break that line into each of the multiplications and debug.print the values before that code
Debug.Print "48*33" & (TextBox48.Value * TextBox33.Value)
Debug.Print "49*34" & (TextBox49.Value * TextBox34.Value)
Debug.Print "50*35" & (TextBox50.Value * TextBox35.Value)
etc
which should crash on the bad line or check in the immediate window to see which one is giving you the error then debug.print the values from each of the text boxes before the row above that crashed

it may be one of the text boxes doesn't have a value set?

 

[Schofi_D]

Your best bet is to break that line into each of the multiplications and debug.print the values before that code
Debug.Print "48*33" & (TextBox48.Value * TextBox33.Value)
Debug.Print "49*34" & (TextBox49.Value * TextBox34.Value)
Debug.Print "50*35" & (TextBox50.Value * TextBox35.Value)
etc
which should crash on the bad line or check in the immediate window to see which one is giving you the error then debug.print the values from each of the text boxes before the row above that crashed

it may be one of the text boxes doesn't have a value set?

Hi Johnny thanks for this, you're actually spot on half the text boxes are blank, i can put some code in to say if its blank then make it 0, hopefully that works