Changing font from a disable textbox

[pezalmendra]

Hi!

I have a userform that sometimes I need to disable a textbox (but want to leave visible the text) and the thing is that everytime I disable the textbox the font of what is written inside becomes grey. Is there a way of changing this? With a code in the macro or whatever... I would like to leave it black.

Thanks a lot!

[BigBas]

Hi Pezal,

Instead of code such as

Please Login or Register  to view this content.

Use

Please Login or Register  to view this content.

Let me know if this helps

[pezalmendra]

Hello Bas!

Yes that was my other chance I was going to use cause at the end locking the textbox solves the main problem. I was only trying to do it the other way so that its not possible to select the inside text. I will try to look a bit more just in case!

Thanks!

[BigBas]

If it's very important that no one access it, you can add some code based on need. For example, if you normally tab from TextBox to TextBox, once it's locked, you can't Tab into it. Now, if you're worried that users will click in the box, then use the TextBox_Enter event.

To do this, try something like the following code:

Please Login or Register  to view this content.

[pezalmendra]

Hey! That one is good!! I like it!

Thanks man!

[BigBas]

Glad to help