ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Aligning edit boxes on the Ribbon (https://www.excelbanter.com/excel-programming/436303-re-aligning-edit-boxes-ribbon.html)

Andy Pope

Aligning edit boxes on the Ribbon
 
Hi,

You could use a combination of Box, Label and Edit controls. Place the
labels within a vertically aligned box.
Then remove the labels from the edit controls. This xml will add a new group
to the Home tab with 2 labels and edit boxes.

<!--RibbonX Visual Designer 1.6 for Microsoft Excel. XML Code produced on
2009/11/18--
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"
<ribbon
<tabs
<tab idMso="TabHome"
<group
id="Group1"
label="Group1"
<box
boxStyle="vertical"
id="Box1"
<labelControl
id="Labelcontrol1"
label="Short"/
<labelControl
id="Labelcontrol2"
label="Long label text"/
</box
<editBox id="Editbox1" /
<editBox id="Editbox2" /
</group
</tab
</tabs
</ribbon
</customUI

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"xp" wrote in message
...
Hi Ron,

This will size the boxes themselves, which is half the battle, but the
labels are text and are still a problem. I can insert a blank space but
the
spaces are sometimes too wide or too narrow to line things up; it looks
better, but is still a problem.

Please let me know if you learn any more or have any further ideas.

Thanks for the tip!

"Ron de Bruin" wrote:

Hi xp

Try to set the width with

sizeString="WWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWW W"


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"xp" wrote in message
...
In the ribbon, when I set up two edit boxes, one above the other, they
don't
line up because the text in the labels are different widths...it looks
pretty
ugly...how can I get the edit boxes to line up correctly or perhaps
right
align?

Thanks!

.



XP

Aligning edit boxes on the Ribbon
 
I'll give this a try; thanks for the help!

"Andy Pope" wrote:

Hi,

You could use a combination of Box, Label and Edit controls. Place the
labels within a vertically aligned box.
Then remove the labels from the edit controls. This xml will add a new group
to the Home tab with 2 labels and edit boxes.

<!--RibbonX Visual Designer 1.6 for Microsoft Excel. XML Code produced on
2009/11/18--
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"
<ribbon
<tabs
<tab idMso="TabHome"
<group
id="Group1"
label="Group1"
<box
boxStyle="vertical"
id="Box1"
<labelControl
id="Labelcontrol1"
label="Short"/
<labelControl
id="Labelcontrol2"
label="Long label text"/
</box
<editBox id="Editbox1" /
<editBox id="Editbox2" /
</group
</tab
</tabs
</ribbon
</customUI

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"xp" wrote in message
...
Hi Ron,

This will size the boxes themselves, which is half the battle, but the
labels are text and are still a problem. I can insert a blank space but
the
spaces are sometimes too wide or too narrow to line things up; it looks
better, but is still a problem.

Please let me know if you learn any more or have any further ideas.

Thanks for the tip!

"Ron de Bruin" wrote:

Hi xp

Try to set the width with

sizeString="WWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWW W"


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"xp" wrote in message
...
In the ribbon, when I set up two edit boxes, one above the other, they
don't
line up because the text in the labels are different widths...it looks
pretty
ugly...how can I get the edit boxes to line up correctly or perhaps
right
align?

Thanks!
.


.



All times are GMT +1. The time now is 04:05 AM.

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