View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ken Ken is offline
external usenet poster
 
Posts: 590
Default Lines user forms

Thanks, couldn't see what was right in front of me.

"Tom Hutchins" wrote:

You can do both with labels. For a box, add a label with no text. Set its
backstyle to transparent but with a visible border. If it's going to enclose
other controls, put the label box in place first or send it to the back, so
it doesn't keep the other controls from getting the input focus. For a
horizontal line, add a label with no text and a height of 1 (or 2). For a
vertical line, add a label with no text and a width of 1 (or 2). You can
change the "line's" color using its BorderColor property. Also, if you
wanted, you could make use of the label's events (click, double-click, etc.)

Hope this helps,

Hutch

"Ken" wrote:

Does anyone know if it is possible to add lines or boxes to dress up user
forms?
Thanks in advance