ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Lines in forms (https://www.excelbanter.com/excel-programming/302785-lines-forms.html)

John Marshall, MVP

Lines in forms
 
How do I add lines to a forms? There does not appear to be a line draw tool.

I need to add a seperator line between two parts of the form.

John... Visio MVP

Need stencils or ideas? http://www.mvps.org/visio/3rdparty.htm
Need VBA examples? http://www.mvps.org/visio/VBA.htm
Common Visio Questions http://www.mvps.org/visio/common_questions.htm



keepITcool

Lines in forms
 
use a label.
no caption.
width 1 px.
backcolor=vbred?

at least it works for me.

keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"John Marshall, MVP" wrote:

http://www.mvps.org/visio/3rdparty.htm



Fred[_17_]

Lines in forms
 
John,

Besisdes using a 1 pixel high label with a background colour, you could also
put the controls of the two parts inside a frame to separate them.

Bye !

"John Marshall, MVP" wrote in message
...
How do I add lines to a forms? There does not appear to be a line draw

tool.

I need to add a seperator line between two parts of the form.

John... Visio MVP

Need stencils or ideas? http://www.mvps.org/visio/3rdparty.htm
Need VBA examples? http://www.mvps.org/visio/VBA.htm
Common Visio Questions http://www.mvps.org/visio/common_questions.htm





John Marshall, MVP

Lines in forms
 
Thanks. I had considered that as an alternate, but I wanted to make sure
that there was no line tool.

John... Visio MVP

Need stencils or ideas? http://www.mvps.org/visio/3rdparty.htm
Need VBA examples? http://www.mvps.org/visio/VBA.htm
Common Visio Questions http://www.mvps.org/visio/common_questions.htm
"keepITcool" wrote in message
...
use a label.
no caption.
width 1 px.
backcolor=vbred?

at least it works for me.

keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"John Marshall, MVP" wrote:

http://www.mvps.org/visio/3rdparty.htm





John Marshall, MVP

Lines in forms
 
Thanks.

The idea is to have a line similar to the line seperating a column of
numbers being summed and the total.

So a skinny label it will be.

John... Visio MVP

Need stencils or ideas? http://www.mvps.org/visio/3rdparty.htm
Need VBA examples? http://www.mvps.org/visio/VBA.htm
Common Visio Questions http://www.mvps.org/visio/common_questions.htm
"Fred" wrote in message
...
John,

Besisdes using a 1 pixel high label with a background colour, you could

also
put the controls of the two parts inside a frame to separate them.

Bye !

"John Marshall, MVP" wrote in message
...
How do I add lines to a forms? There does not appear to be a line draw

tool.

I need to add a seperator line between two parts of the form.

John... Visio MVP

Need stencils or ideas? http://www.mvps.org/visio/3rdparty.htm
Need VBA examples? http://www.mvps.org/visio/VBA.htm
Common Visio Questions http://www.mvps.org/visio/common_questions.htm








All times are GMT +1. The time now is 12:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com