userform - textbox

[mortgageman]

I'm not sure if this is an Excel gotcha. I have disabled the textboxes on my wari game userform (to prevent the users from cheating *ahem* I meant changing them during the game). Since this makes the numbers looks (too) grey I went to the VBA editor and changed the font to BOLD (just like I was taught on this board ) However, it had no effect. When I show the userform it was still just as grey.

Is there any way to disable a textbox but still make the text in the box look darker?

Gene, "The Mortgage Man", Klein

 

[XLGibbs]

I think if you disable, or even "lock" the textbox, you can set the back and fore color properties at the same time...I think you can change the font color by changing the ForeColor proprety ...I would think the event that triggers locking them would be able to similarly affect the forecolor

 

[Norie]

Gene

What code did you use to disable the textboxes?

Did you set the Enable property to False?

Why not set the Locked property to True?

 

[mortgageman]

What code did you use to disable the textboxes?

Did you set the Enable property to False?

Why not set the Locked property to True?

Because I didn't know about it! I do now. Thanks.

Gene, "The Mortgage Man", Klein