Help with code restricting TextBox entry
On Sep 21, 2:04*pm, Dave Peterson wrote:
A label is another control on the userform toolbar.
It's like a textbox that the user can't change.
if someerrorcondition = true then
* * me.label1.caption = "Error message here"
else
* * me.label1.caption = ""
end if
On 09/21/2010 13:50, jeff wrote:
<<snipped
Thanks Dave. I'm sure your way is the most efficient. However, I'm not
sure what a Label is that you're suggesting. I've never done them. I
looked it up, and I still don't get what they are/do. I tried to put
one in, and all I got was some of the characters on the userform
changed, like there was something behind the textboxes.
I'll keep looking at how the labels work. Meanwhile, I'll have to
settle on the work-arounds.
Thanks for your help.
j.o.
--
Dave Peterson
Ok. I know about the label one might put above the textbox. I use
those to label the textboxes. I didn't know this was what you were
refering to. The concept of creating one based on conditional
statements.... this is what I'm not familiar with. I think I'll get my
John Walkenbach book out, and learn about this before I move ahead.
Thanks for your time and patience.
j.o.
|