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? [TABLE="width: 160"]
<tbody>[TR]
[TD="colspan: 2"]Private Sub TextBox1_Change()
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]Dim StrTestInput As String
[/TD]
[/TR]
[TR]
[TD="colspan: 2"]StrTestInput = TextBox1.Text
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]Sheet2.TextBox1.Text = StrTestInput
[/TD]
[/TR]
[TR]
[TD]End Sub
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[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