How to prevent a user from changing a text in a textbox ?

[francois.lemarie]

I need to prevent a user to modify a textbox (Control ActiveX). Does anyboday know how to do ?

 

[Norie]

Perhaps you could use some other control, one which can display data but can't be edited.

 

[AlphaFrog]

You could use a "Label" control. Or if you want to toggle the ability to edit the text in the Textbox, you could set its Enable property to True\False using VBA e.g

Sheets("Sheet1").TextBox1.Enabled = False   'Can't edit Textbox1

Or to toggle enabled True\False...
Sheets("Sheet1").TextBox1.Enabled = Not Sheets("Sheet1").TextBox1.Enabled

 

[Jaafar Tribak]

Try this :

Private Sub TextBox1_KeyDown _
(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
 
    KeyCode = 0
    
End Sub

 

[francois.lemarie]

Thanks a lot everybody.

 

[pstraton]

After defining its text value, why not just set its Enabled property to False?

 

[AlphaFrog]

After defining its text value, why not just set its Enabled property to False?

I believe that was suggested in post #3 five years ago.