Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

"some" calculation in VBA excell 1

Status
Not open for further replies.

Joep1972

Technical User
Nov 24, 2002
13
NL
Hi,

I've got the following code(only a part),

Worksheets("test").Cells(15, 8).Value = Som("Worksheets("test").Cells(15, 8): Me.TextBox1.Text")

What I want to do is,

put the value of textbox1 in cell H15 BUT in this cell is already a number.

Now I want a code that calculate this ( so the som of the textbox and the value that's already in cell H15

thx

Joep

 
Worksheets("test").Cells(15, 8).Value = Worksheets("test").Cells(15, 8)+ Me.Textbox1.value

should do the trick Rgds
~Geoff~
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top