Forum Discussion

sf49ers19238597's avatar
sf49ers19238597
Iron Contributor
Jan 18, 2024
Solved

I have idea three textboxes on a userform

I have idea three textboxes on a userform.

 

Textbox1

Textbox2

Textbox3

 

How make them not editable  or click on textboxes.

 

 

Thanks you

 

  • sf49ers19238597 

    Text boxes on a userform have 2 relevant properties: Enabled and Locked.

     

    If Enabled is False, the user won't be able to click in the text box (and hence not be able to edit its contents).

     

    If Enabled is True (the default), the user can click in the text box and select text in it. If, in addition, Locked is set to True, the user won't be able to edit the contents, but if Locked is set to False (the default), the user will be able to edit.

     

  • sf49ers19238597 

    Text boxes on a userform have 2 relevant properties: Enabled and Locked.

     

    If Enabled is False, the user won't be able to click in the text box (and hence not be able to edit its contents).

     

    If Enabled is True (the default), the user can click in the text box and select text in it. If, in addition, Locked is set to True, the user won't be able to edit the contents, but if Locked is set to False (the default), the user will be able to edit.

     

Resources