Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
More than one User Forms TotallyConfused Excel Programming 3 December 3rd 07 05:18 AM
lines in user forms jparker9 Excel Programming 3 February 3rd 06 03:11 PM
user forms Brian Excel Programming 2 October 23rd 04 04:17 PM
Lines in forms John Marshall, MVP Excel Programming 4 June 29th 04 04:39 PM
User forms eklarsen[_7_] Excel Programming 5 May 17th 04 05:36 AM


All times are GMT +1. The time now is 01:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"