Data from one textbox to another

[VaibhavAr]

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?

[BadlySpelledBuoy]

Please Login or Register  to view this content.

BSB

[VaibhavAr]

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?

[BadlySpelledBuoy]

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

[VaibhavAr]

I tried it. Not happening.

Please Login or Register  to view this content.

[BadlySpelledBuoy]

Where did you put the code?

Could we see the workbook?

BSB

[VaibhavAr]

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.

[BadlySpelledBuoy]

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

[VaibhavAr]

Ya it works. Sorry. My misunderstanding. Thank you so much...

[VaibhavAr]

Can I paste only 054 in one textbox if I enter IF/SOS/054/1617 in the other?

[bakerman2]

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.

[VaibhavAr]

The input will be consistent. only the number "054" will change.

[bakerman2]

Please Login or Register  to view this content.

[VaibhavAr]

I tried it but it still saves the complete text. Not the number.

[BadlySpelledBuoy]

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

[VaibhavAr]

Works perfectly fine. Thanks..

[BadlySpelledBuoy]

Happy to help

BSB