Hi Neil,

Try the Locked property.

Cheers
Andy

Neil wrote:

Hi, I have a form with a lot of textboxes on it, they are
confirgured as Borderstyle single, and are right next to
each other so that it looks like a spreadsheet, at form
load I do a loop around some values ex a query from an
external data source and populate the textboxes down the
left hand side, to prevent people from changing the data
in these textboxes I have set them as Enabled = False.
But this causes the text to become grey, is there any way
I can keep the text black but prevent the contents of the
textbox from being changed ?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info