Is there a way to paste to a textbox?

[imaquila]

I see that someone has asked this before but I saw no replies to the question. I'm using a text box on a user form but sometimes, I'd rather copy the information and paste it to my text box to avoid typos, rather than type it in. I find that my textbox will not allow me to paste to it. Is there a setting or something that can be used to enable the pasting behavior? Thanks for your assistance!

 

[rlv01]

There is a textbox property named "Locked". If you set it to FALSE, you should be able to paste text from the clipboard into it.

 

[imaquila]

There is a textbox property named "Locked". If you set it to FALSE, you should be able to paste text from the clipboard into it.

Thanks very much. I checked but apparently the default for "Locked" is FALSE. I experimented by changing it to TRUE but then I found out that not only could I not paste to it, I also could no type directly in it. Please let me know if you have any other suggestions. Thanks

 

[rlv01]

I have several workbooks that use form textboxes for editing purposes. I paste data to them all the time, and it is the .Locked property that controls whether or not I can paste to them. Also, make sure that the

MultiLine = True
EnterKeyBehavior = True

Properties are true. They don't prevent pasting, but the wrong behavior can confuse things.

 

[imaquila]

I have several workbooks that use form textboxes for editing purposes. I paste data to them all the time, and it is the .Locked property that controls whether or not I can paste to them. Also, make sure that the

MultiLine = True
EnterKeyBehavior = True

Properties are true. They don't prevent pasting, but the wrong behavior can confuse things.

Thanks for tip about EnterKeyBehavior. I've not used that one before but I was familiar with MultiLine. As you predicted, changing the settings did not get my "Paste" option to pop up with a right click of the textbox but I'm happy to learn something new on the way to finding the solution that will allow me to Paste.
I should also mention that I'm NOT trying to copy something from my table to paste. In researching, I've seen that trying that apparently causes a similar problem. In any case, I do appreciate your time in trying to help. Thanks

 

[rlv01]

Try using the keyboard Ctrl-V key combination to paste instead of looking for a right click context menu.

 

[imaquila]

Try using the keyboard Ctrl-V key combination to paste instead of looking for a right click context menu.

That does work. Thanks for the help.