Command Button to update the multiple line items in a TextBox

**aaron.mendes** · 10-15-2013, 10:29 PM

I have created a Userform and after updating details in the form, on clicking OK (command button) i want the user form to populate the details in a Textbox.

However, there will be multiple lines that i would want to update in the text box. So after clicking OK once, the text box would be updated. Then i would fill in different details in the form and after clicking OK again, another line would get created in the same text box.

Can someone please help.

This is my current OK button Code.

Code:

Private Sub OKButton_Click()

Dim emptyRow As Long

'Make Sheet1 Active
Sheets(1).Activate

'Determine EmptyRow
emptyRow = WorksheetFunction.CountA(Range("A:A")) + 1

'Export Data to worksheet
Cells(emptyRow, 1).Value = COB_Date.Value
Cells(emptyRow, 2).Value = Client_Name.Value
Cells(emptyRow, 3).Value = NameTextBox.Value
Cells(emptyRow, 4).Value = Disputed_Amount.Value


End Sub

**alansidman** · 10-16-2013, 12:37 AM

**aaron.mendes** · 10-16-2013, 01:40 PM

Dispute Commentary 1.xls

I have attached my file. I want the data that i fill in the form like COB date, Client NAme, Rec Owner Name etc to be updated in different lines in the Commentary Textbox.

**alansidman** · 10-16-2013, 08:30 PM

I have made some changes/additions to your code. I hope this is what you are looking to do.
1. Created a text box for COB_Date
2. Put code behind cancel button
3. Put code behind clear button
4. Added code to OK button to clear text boxes after update.
5. Set tab order of events to follow the order of the text boxes and command buttons.
6. Added a command button to load the data from the text boxes to the commentary.
7. Set the properties in the commentary box for multi-line to TRUE

I did notice that the commentary box does not go anywhere. It is not saved to any particular location on your spreadsheet. Is this an oversight?

**aaron.mendes** · 10-16-2013, 09:25 PM

Hi Alan - thanks, this is super stuff. Yes, your right, This was an oversight.

I want the data from the Commentary Textbox to export to excel. However, I would be adding multiple data (COB date/Client Name/Rec owner name) to the commentary text box.
So in essence, after I click "To Commentary", the text boxes above should get cleared to help me add more data and then click To Commentary Again which would add more line to the commentary text box.

thanks for your help again.

**alansidman** · 10-16-2013, 09:44 PM

Test drive it as it is and make sure it does what is expected before you add new bells and whistles.

**aaron.mendes** · 10-16-2013, 09:56 PM

Hey - yes, i checked the codes. It works exactly like what i need. Just need to be able to add more data to the Commentary textbox creating multiple lines.

"So in essence, after I click "To Commentary", the text boxes above should get cleared to help me add more data and then click To Commentary Again which would add more line to the commentary text box.

**alansidman** · 10-17-2013, 12:29 AM

No. The text boxes currently above clear after you click on the OK button. Can you be specific in the steps that you want to take. This will help to design the flow of data using VBA. Right now, I am now sure of the flow of data.

**aaron.mendes** · 10-17-2013, 02:39 PM

Hi Alan - I'm sorry for not being clear enough. I have attached the file as to how my form should look like. I have also attached a .jpg file for the flow. Please help me. Thanks for your help.

Picture1.jpg