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  
  • HansVogelaar's avatar
    Jan 18, 2024

    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.