Make a textbox Read Only using Excel 2000 VBA

[vestax22]

Hi, I just want to know how to make a textbox read only without setting the enabled property to false.

I use a method called setfocus on these textboxes which requires them to be enabled.

Any help would be appreciated.

 

[SQLBI]

The textox should have a Locked property which is initially set to false, by changing this to true either in the properties window, or at runtime it should prevent any editing of the TexBox contents.

Leigh Moore
LJM Analysis Ltd

http://www.ljm-analysis.co.uk

 

[Bowers74]

If you don't want the user to be able to select the text either (i.e. to copy it elsewhere) then you should use a Label and format to look like a TextBox (i.e. BackColor = White or Grey & SpecialEffect = Sunken).

If you only want to prohibit the user from inserting or typing text into the TextBox, then follow leighMoore's suggestion, it is easier and invloves less formatting.

Have Fun!



If you can't be "The Best", be the best at what you can!!!

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