LinkBack URL
About LinkBacks
During running the userform for data entry, when I am writing something in a particular textbox, it should paste the same / reflect the same in a different textbox in the same form.
Any suggestions?
Data from one textbox to another
During running the userform for data entry, when I am writing something in a particular textbox, it should paste the same / reflect the same in a different textbox in the same form.
Any suggestions?
BSB
Please Login or Register to view this content.
Will this code show me the data in real time during entering it in the form or will it be just saved in the backend?
As you type in one textbox it will appear in the other simultaneously.
Cannot imagine why you'd need to do this though. Duplication seems odd.
BSB
I tried it. Not happening.
Please Login or Register to view this content.
Where did you put the code?
Could we see the workbook?
BSB
http://www.excelforum.com/attachment...1&d=1464321748
I am unable to attach the file. Please check if this link works. I will look for another alternative till then. Else you can share your email ID.
It works perfectly well for me. If I open the userform in your attachment and type into the "Complaint No." textbox the same appears in the "IF SOS Number" textbox.
BSB
Ya it works. Sorry. My misunderstanding. Thank you so much...
Can I paste only 054 in one textbox if I enter IF/SOS/054/1617 in the other?
Possible if there is some consistency in your input. If it's always the value between the last 2 forward slashes it's possible to write code in an AfterUpdate-event.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
The input will be consistent. only the number "054" will change.
Please Login or Register to view this content.
I tried it but it still saves the complete text. Not the number.
See attached.
I've added bakerman2's code and deleted the change event code you added previously (post #5) so there is no conflict between them.
bakerman2's code works just fine. Note it will only populate the other textbox when you click out of the Complain No. textbox as opposed to a live update as you type.
BSB
Last edited by BadlySpelledBuoy; 06-01-2016 at 05:35 AM.
Works perfectly fine. Thanks..
Happy to help
BSB
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks