Share via

how can i disable a textbox but the text should stay dark

Anonymous
2015-05-16T22:56:27+00:00

i have some textboxes in a userForm  that bring up values from the sheets. 

there is no need to enter text manually so i set it  Enable = false

but then, the values get very light.

how can i disable  the textbox but the text should stay as normal?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. HansV 462.6K Reputation points MVP Volunteer Moderator
    2015-05-16T23:03:51+00:00

    You could set the Enabled property of the text box to True, and its Locked property to True also. That way, the text will not be grayed out. The user will be able to click in the text box, but the text cannot be edited.

    If you set the TabStop property of the text box to False, the user cannot accidentally tab into the text box.

    1 person found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest