Pasting text in an ActiveX Textbox

[naivegeye]

I am working on a spreadsheet that asks the user to input a description into an ActiveX textbox. The textbox is mirrored on another sheet. Below is the code. The problem I have is the ActiveX TextBox1 will not allow the user to paste text into the box. Is there a property setting I can use to allow pasting?

Private Sub TextBox1_Change()
Dim StrTestInput As String
StrTestInput = TextBox1.Text
Sheet2.TextBox1.Text = StrTestInput
End Sub

<tbody>
</tbody>

 

[CharlesChuckieCharles]

I take it that it is possible to type text in?

 

[naivegeye]

I take it that it is possible to type text in?

Yes, it was possible. Actually, it is working today. I must of changed one of the properties.

Thank you.

 

[01's]

Hi, I understand that this is old thread but i also have same issue with text box.
How do I disable pasting in text box but keep typing enabled.

Thanks