Command Button to update the multiple line items in a TextBox

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.

Please Login or Register  to view this content.

if you are trying to add a new line the text box each time (assuming you are in the userform) try:

Please Login or Register  to view this content.

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.

Can you provide a sample of what you would want the textbox output to look like and what lines would get updated. It might be simpler to just re-input the entire contents of the textbox each time if it just 4 lines

Below is a sample for the output. These should be a set of details. One Question here is that, can the labels highlighted in Bold also get updated as a Header in the output textbox

COB Date: 10/14/2013
Client Name: BNP – 33417
Rec Owner Name: Aaron
Disputed Amount: 1,000,000



I would be later adding more textboxes in the form so that the Output Textbox gets updated on the click of the command button.

You might be better off using a listbox, that way you can output multiple columns and rows and easily change any item.

How would that be possible. I'm sorry, I'm quite an amateur in VBA and still learning alot.

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

No worries, i have given two solutions in the attached file, a listbox with 6 columns or the textbox method. You could use a combination and have a listbox with 2 columns displaying the same output as the textbox method, it depends on how you want the form to display. Currently both methods are active, just delete the one you don't want

Dispute Commentary - Updated.xls

Hi Alan - Thanks for shedding light on the cross posting rules. Does make sense not to duplicate someone's work.


Hi Nigel - I have a question. I am adding the textbox2 (Reason for Dispute) and textbox3 (Miscellaneous Comments)codes to the commandbutton click. but it gives me the below error. Here is my code

Please Login or Register  to view this content.

Compile error "wrong number of arguments or invalid property assignment"

Also, i want to understand the codes for ExportContents and OutputTextbox that you have used.

Thanks for your help once again.

you will have to remove the last two arguments from that call (the two "") they were just placeholders I made for the textbox2 and textbox3 values.

Hi Nigel - Thanks. Now i have created the exact form as per my requirement by adding more text boxes. Needed your few help over little items which should be an easy go considering your expertise.

1) When I click 'To Commentary' multiple times adding more data, there are blank rows created in the Commentary Box when i dont update a particular textbox. Is it possible for the data to be entered in the next line itself instead of creating blank rows.

2) On the userform, can there be static data, that can be a part of the output in the Commentary Box? For e.g. 'MO/Contact Query Riased', can this be a part of the data. I would need to add some more textboxes/label to complete the userform.

3) I'm not sure i would require the codes for ExportContents and Output Textbox. You would know better though.

4) Lastly, by clicking the TAB button on the keyboard, is it possible for the cursor to move as per the textboxes as per my requirement just to make the form userfriendly.

I have attached my file and a sample desired output in excel as to how i would want it to be. Please help.
Thanks once again.

1) Yes, just check if the value has been entered in the textbox, if it has then add it to the commentary box eg:

Please Login or Register  to view this content.

2)Yes, add the static data as you would any other textbox (or output to the spreadsheet as currently with the other textboxes)

3)You seem to have commented out all the added code so I am unsure of how you are doing it and hence what you will need. If your code does not call the function you will not need it (if in doubt, comment out the function first and test it)

4)Yes, select the textbox, in the properties section you will see a property called 'TabIndex', change this for all the textboxes to the order you want

Hope this helps