PDA

View Full Version : Solved: Userform Quick Q



blackie42
07-02-2008, 09:14 AM
Hi

Is it possible to add the values of 2 textboxes together and send the result to a cell.

range("G8") = textbox1.value + textbox2.value

15 in TB1 & 15 in TB2 gives 1515 not 30

thanks

Jon

Bob Phillips
07-02-2008, 09:33 AM
Range("G8").Value = Val(TextBox1.Value) + Val(TextBox2.Value)

blackie42
07-02-2008, 10:33 AM
Thanks for the steer XLD

regards

Jon