Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Restricting entry | Excel Worksheet Functions | |||
Restricting Duplicate Entry | Excel Worksheet Functions | |||
Restricting entry in B1 on the basis of entry in A1 | Excel Worksheet Functions | |||
Restricting entry in B1 on the basis of entry in A1 | Excel Worksheet Functions | |||
Text Box - Restricting Entry | Excel Programming |