View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jeff jeff is offline
external usenet poster
 
Posts: 48
Default 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.