Userform TextBox when dumps value in worksheet cell table structure is disturbed
Hi friends
got question
in a userform their is a text box enabled with multiline comments...when this textbox paste its value in worksheet the whole structure of worksheet is messed. ....
is thier any way , when text box of userform when paste its value to worksheet it will also give the cell the property of the Vertical scrollbar
....
awating reply with some codes
thanks in advance
Text from a multiline text box is pasted as multiple cells.
Cells cannot have scrollbars.
If you want to copy the contents to a single cell, use this code rather than a copy/paste:
Please Login or Register to view this content.
Re: Userform TextBox when dumps value in worksheet cell table structure is disturbed
Hi friend
cant figure out how to do where to paste .....i am using USERFORM
----------
TextBOx----Name :- "notes_tbox"
Userform---Name :- "entry_form"
Attach your file, or at a minimum list all your code. At what point in the flow do you want to store the textbox to the cell?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks