How do you add 2 numbers together in VB from a worksheet?

[anoble1]

Hi,

I have an excel sheet that has a graph in it. The graph is a line graph and has bars that contain 2 numbers that add together that create 1 bar. I have made a textbox that has "Active X" functions on it. meaning that the textbox pulls from VB code. Anyone know of the code to grab numbers from a worksheet and add them together?

EX:

Private Sub TextBox1_Change()
Sheets("Sheet1").Select
Range("F4:G4").Select
textbox = F4.value+G4.value
End Sub

Maybe something like that but that will not work.

i am just trying to populate a textbox with VB by adding 2 numbers from a worksheet.

[ADezii]

There are several ways to accomplish this, namely:

1. Directly assign Result to Textbox on Form:
   

   TextBox1 = Cells(4, 6) + Cells(4, 7)
   TextBox2 = Range("F4") + Range("G4")

2. Apply Formula to Cell:
   

   =SUM(F4:G4)

[Rabbit]

This thread has been moved to the new Excel forum.