Please help me!
I have been struggling (again) with this problem for hours and I can't seem to solve it. I have searched the forums and I have strung some things together but nothing is doing exactly what I need.
I need to populate a multiline textbox with range B3:B32.
Here is what I have so far:
Currently, I am getting either a "type mismatch" or a runtime error.
Please Login or Register to view this content.
I would greatly appreciate any help you could offer.
Is TbClist the textbox?
If it is remove Controls, and you might want to do a little concatenation.
You could also try this.Please Login or Register to view this content.
Please Login or Register to view this content.
If posting code please use code tags, see here.
Hi Norie. Thank you! I have read many of your posts.
Yes, TbCList is the textbox name.
I'll give this a go and get back to you
Both work thanks, Norie.
Would there be a way to use this withso as to not copy blank cells/lines into the textbox?HTML Code:
I have tried this:
to no avail.Please Login or Register to view this content.
Thanks again!
Perhaps.
Please Login or Register to view this content.
You, my friend, are a genius! This is a huge help.
The textbox had to populate without any blank rows as the textbox saves this list back to the same range.
Thank you so much for your time. It is greatly appreciated.
Sorry to bother you again
There is an error when there is only one name in the list on the line:
No doubt this is because there is no array.Please Login or Register to view this content.
I'm trying to use an if statement to trap this error but I can't seem to introduce it.
UPDATED:
I have fixed this by preceding this with an "If ... Then Exit Sub" statementAlso, when there is nothing in the range B3:B32, the textbox shows the value of cell B2? That must be the xlup as B2 has text in it. However, the array should start from B3 (see your post). As always, there is no quick fix
Any ideas, Norie?
Last edited by Sc0ut; 01-20-2015 at 07:43 AM.
Perhaps.
PS Have you considered using a ListBox instead of a multiline TextBox?Please Login or Register to view this content.
Thanks, Norie. I'll give this a go.
Unfortunately I can't use a ListBox as I need to be able to paste in a list of names into the TextBox. This list then populates the range B3:B32 on the sheet.
I'll get back to you shortly. Many thanks, Norie! You're a champion!
That worked perfectly! That's that fixed. Thanks again for your help, Norie.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks