JumboCactuar
Well-known Member
- Joined
- Nov 16, 2016
- Messages
- 788
- Office Version
- 365
- Platform
- Windows
Hi,
I have a userform which has a multi line text box for data input (textbox1)
And a single line textbox (textbox2)
How would I transfer the text from textbox1 to columnA (after last row of data) and textbox to ColumnB
Example:
Last row of table data is 17
Textbox 1 has 6 lines so should output to A18:A23
Textbox 2 data output to B18
Thanks for any help
I have a userform which has a multi line text box for data input (textbox1)
And a single line textbox (textbox2)
How would I transfer the text from textbox1 to columnA (after last row of data) and textbox to ColumnB
Example:
Last row of table data is 17
Textbox 1 has 6 lines so should output to A18:A23
Textbox 2 data output to B18
Thanks for any help