I see, yes it makes sense.

The only thing you have to do is put the textbox inside a frame control. Delete the
frame's caption and border if you want it "invisible" for layout reasons. Then you can
just toggle it like

Frame1.Enabled = Not Frame1.Enabled

and leave the textbox as is, no alterations needed.

--
HTH. Best wishes Harald
Excel MVP

Followup to newsgroup only please.

"Mike NG" wrote in message ...
On Wed, 30 Jul 2003 at 00:15:11, Harald Staff (Harald Staff
) wrote:
Why spend time learning a cat to bark when you can have a dog ? What do you want the
textbox to do that a label can't ?

In one mode to be a textbox, but in the other for it to behave like a
label, i.e. display only and not landable. My form has several fields
and having two userforms would be wasteful, especially since most of the
code does the same thing in the two modes.

On Wed, 30 Jul 2003 at 08:33:28, Harald Staff (Harald Staff
) wrote:
The only thing you have to do is put the textbox inside a frame control. Delete the
frame's caption and border if you want it "invisible" for layout reasons.

Many thanks.

I was wondering if, using your original analogy, I could have taught a
dog to be a cat, but that wouldn't have worked either
--
Mike