ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Align Text in Command button (https://www.excelbanter.com/excel-discussion-misc-queries/207793-align-text-command-button.html)

Wanna Learn

Align Text in Command button
 
Hello How Do I align the text in a command button on the left. I do not
want it centered. thanks

ShaneDevenshire

Align Text in Command button
 
Hi,

Active X Command buttons are not designed to support this.

You can do this with a button created in the spreadsheet using the Forms
toolbar's Button tool. Select the button and click the Left align button.

For command buttons created in the spreadsheet or on userforms you can only
do this by adding a picture of the text you want to button. Create a picture
of the text you want in a program that will let you save it as a picture
file. Then add it to the buttons Picture property.

If this helps, please click the Yes button.
--
Thanks,
Shane Devenshire


"Wanna Learn" wrote:

Hello How Do I align the text in a command button on the left. I do not
want it centered. thanks


Dave Peterson

Align Text in Command button
 
You may be able to pad to the right with white spaces.

I'd use the space character to get to the last character and then use the HTML
non-breaking space (alt-0160 from the numeric keypad).

You may want to change the font to a non-proprotional font like Courier New,
too.

Wanna Learn wrote:

Hello How Do I align the text in a command button on the left. I do not
want it centered. thanks


--

Dave Peterson


All times are GMT +1. The time now is 09:49 PM.

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