Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
SOLVED

I have idea three textboxes on a userform

Iron Contributor

I have idea three textboxes on a userform.

 

Textbox1

Textbox2

Textbox3

 

How make them not editable  or click on textboxes.

 

 

Thanks you

 

1 Reply
best response confirmed by sf49ers19238597 (Iron Contributor)
Solution

@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.

 

HansVogelaar_0-1705612415234.png

1 best response

Accepted Solutions
best response confirmed by sf49ers19238597 (Iron Contributor)
Solution

@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.

 

HansVogelaar_0-1705612415234.png

View solution in original post