Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Command button align text | Excel Discussion (Misc queries) | |||
Pivot Table Error Message - "Command Text not set for command obje | Excel Discussion (Misc queries) | |||
Command button text | Excel Discussion (Misc queries) | |||
Enable Command Button After Entering Text | New Users to Excel | |||
Is there a Wrap Text command button? | Excel Discussion (Misc queries) |