PDA

View Full Version : Disable all textboxes in a userform



ProteanBeing
02-11-2008, 09:44 AM
I have a user form that I use to enter in a large amount of date per row. I would like to use this same userform to let others SEE the data. Is there a way to disable everything or do I have to do them one at a time?

Norie
02-11-2008, 10:13 AM
Yes, but you could do it in a loop.

But why have multiple textboxes in the first place.:)

Couldn't you display the data in a listbox?

Then the user could see it but couldn't alter it.