Change font on disabled textbox

[daseffects]

I have a textbox on a form that I'm using to show data that using controlsource - Sheet1!AR12 - I've disabled it so users can not type over it. However, once disabled I can't edit the font.

Any work arounds or thoughts?

D

 

[Bowers74]

Enable the TextBox
Change it's Font
Disable the TextBox

So instantaneous you won't notice it! ;-)



Peace!

Mike

Never say Never!!!
Nothing is impossible!!!

 

[daseffects]

Looking to change the font color which enable changes to a dark grey.

 

[Bowers74]

One tip for you:

If you don't want the user to use the TextBox, then Lock it don't Disable it. If the user isn't supposed to be able to do anything with the text in the TextBox (even Copy it) then make the Text Box a Label and format it to "look" like a TextBox.

;-)



Peace!

Mike

Never say Never!!!
Nothing is impossible!!!

 

[Josh1]

Hi:
I am trying to write a macro that will save a designated range or sheet as a seperate workbook and convert all formulas to values in the process (excel VBA).

Anybody have any ideas?

Thanks