View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Patrick Molloy Patrick Molloy is offline
external usenet poster
 
Posts: 1,049
Default Text labels on a Userform

you could add another label. make it big enough to cover all the forms
labels, make it transparent and bring it to the front. then you only have to
handle one click event. You may need a couple if you can't reorganize the
labels, but it might mean coding a few new labels rather than many ...just
an idea

"Robert Crandal" wrote in message
...
For my userform, I am handling "UserForm_Click()" to detect
when someone clicks on the form. The problem is, my
Userform contains about 20 individual "text label" controls
which sit on top of the form. Therefore, UserForm_Click()
only gets called someone clicks an area that is not covered
by a text label....

Is there an easy way to detect if someone clicks on ANY
area of the userform?? I fear that I might have to handle
20 individual "Label_Click()" functions in addition to
the UserforClick() function, which seems like overkill.

thank u