Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Textbox question?
I am using a userform to have data transfered to a sheet. I currently use
the code below to send it to a worksheet but what I would like to have happen is for it to add the total of the textbox to the total already in the cell. How do I do that? Thanks Greg |
#2
|
|||
|
|||
Here is the code
R = 3 'or whatever desired row variable Sheets(2).Cells(R, 5).Value = TextBox4.Text "Greg B" wrote in message ... I am using a userform to have data transfered to a sheet. I currently use the code below to send it to a worksheet but what I would like to have happen is for it to add the total of the textbox to the total already in the cell. How do I do that? Thanks Greg |
#3
|
|||
|
|||
Hi,
You can do it like this: R = 3 'or whatever desired row variable dim cellValue as integer cellValue = Sheets(2).Cells(R, 5).Value Sheets(2).Cells(R, 5).Value = cellValue + TextBox4.Text -- http://blog.jausovec.net "Greg B" je napisal: Here is the code R = 3 'or whatever desired row variable Sheets(2).Cells(R, 5).Value = TextBox4.Text "Greg B" wrote in message ... I am using a userform to have data transfered to a sheet. I currently use the code below to send it to a worksheet but what I would like to have happen is for it to add the total of the textbox to the total already in the cell. How do I do that? Thanks Greg |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extract Data From Textbox | Excel Worksheet Functions | |||
Rich Textbox | Excel Discussion (Misc queries) | |||
manipulating textbox in chart | Charts and Charting in Excel | |||
An easy macro question and one I believe to be a little more diffi | Excel Worksheet Functions | |||
Help needed with textbox formatting in Excel 2000 | Excel Discussion (Misc queries) |