C Chip Pearson Apr 21, 2005 #2 I don't believe that Label controls support vertical alignment. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
I don't believe that Label controls support vertical alignment. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
G Guest Apr 21, 2005 #3 What can I do to make my text look centered in the label? Mine looks like it is top centered?
P Peter T Apr 21, 2005 #4 This came up recently in subject "CommandBar Caption Orientation" and Dave Peterson suggested suggested: "Separate each character by ctrl-enter (to force a new line)" - which at the time I thought was a neat idea! If your text has only one vertical line that should work for the label caption. Regards, Peter T
This came up recently in subject "CommandBar Caption Orientation" and Dave Peterson suggested suggested: "Separate each character by ctrl-enter (to force a new line)" - which at the time I thought was a neat idea! If your text has only one vertical line that should work for the label caption. Regards, Peter T
S Stephen Bullen Apr 21, 2005 #5 Hi Teb2, What can I do to make my text look centered in the label? Mine looks like it is top centered? Click to expand... Use two labels, one for the background/border, one (transparent) for the text and center them with code: lblFront.Top = lblBack.Top + (lblBack.Height - lblFront.Height) \ 2 and the same for the left/width Regards Stephen Bullen Microsoft MVP - Excel Professional Excel Development The most advanced Excel VBA book available www.oaltd.co.uk/ProExcelDev
Hi Teb2, What can I do to make my text look centered in the label? Mine looks like it is top centered? Click to expand... Use two labels, one for the background/border, one (transparent) for the text and center them with code: lblFront.Top = lblBack.Top + (lblBack.Height - lblFront.Height) \ 2 and the same for the left/width Regards Stephen Bullen Microsoft MVP - Excel Professional Excel Development The most advanced Excel VBA book available www.oaltd.co.uk/ProExcelDev
