ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,284
- Office Version
- 2007
- Platform
- Windows
Evening.
Can you help please with a basic code where once two values are entered into two TextBoxes on a userform the command button will run the code adding these values to the existing cell values.
Some info for you.
Userform will have Textbox1 & Textbox2
Also the Commandbutton1
Range on worksheet will be A10:B25
The code should check for last cell in column A & B then paste new value over existing value.
The code should work like this.
I open the Userform.
I enter a value in Textbox1 & also Textbox2
When I press Commandbutton1 the code should look in column A & B for the last cell with a value in it.
My entered value in Textbox1 should be added to the cell in column A & my entered value in Textbox2 should be added to the cell in column B
Have a good night.
Thanks.
Can you help please with a basic code where once two values are entered into two TextBoxes on a userform the command button will run the code adding these values to the existing cell values.
Some info for you.
Userform will have Textbox1 & Textbox2
Also the Commandbutton1
Range on worksheet will be A10:B25
The code should check for last cell in column A & B then paste new value over existing value.
The code should work like this.
I open the Userform.
I enter a value in Textbox1 & also Textbox2
When I press Commandbutton1 the code should look in column A & B for the last cell with a value in it.
My entered value in Textbox1 should be added to the cell in column A & my entered value in Textbox2 should be added to the cell in column B
Have a good night.
Thanks.