text boxes
 

Hi all,

I have a textbox within a userform that displays a value. I don't want any
users to be able to edit this information. How do I go about this?

Thanks in advance
Dawna

text boxes
 

Set the "enabled" property to false.


"Dawna" wrote in message
...
Hi all,

I have a textbox within a userform that displays a value. I don't want any
users to be able to edit this information. How do I go about this?

Thanks in advance
Dawna

text boxes
 

Change its Locked property for the TextBox to True in the Properties Box.

--
Rick (MVP - Excel)


"Dawna" wrote in message
...
Hi all,

I have a textbox within a userform that displays a value. I don't want any
users to be able to edit this information. How do I go about this?

Thanks in advance
Dawna

text boxes
 

Note... the difference between my suggestion and ZootRot's suggestion is
mine allows the user to copy data from the TextBox to the Clipboard whereas
ZootRot's does not.

--
Rick (MVP - Excel)


"Rick Rothstein" wrote in message
...
Change its Locked property for the TextBox to True in the Properties Box.

--
Rick (MVP - Excel)


"Dawna" wrote in message
...
Hi all,

I have a textbox within a userform that displays a value. I don't want
any
users to be able to edit this information. How do I go about this?

Thanks in advance
Dawna

text boxes
 

Thank you both for the replies. That's exactly what I needed.

"Rick Rothstein" wrote:

Note... the difference between my suggestion and ZootRot's suggestion is
mine allows the user to copy data from the TextBox to the Clipboard whereas
ZootRot's does not.

--
Rick (MVP - Excel)


"Rick Rothstein" wrote in message
...
Change its Locked property for the TextBox to True in the Properties Box.

--
Rick (MVP - Excel)


"Dawna" wrote in message
...
Hi all,

I have a textbox within a userform that displays a value. I don't want
any
users to be able to edit this information. How do I go about this?

Thanks in advance
Dawna


.