Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 318
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,344
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Command button align text Wanna Learn Excel Discussion (Misc queries) 0 July 18th 08 03:48 PM
Pivot Table Error Message - "Command Text not set for command obje Jeff Divian Excel Discussion (Misc queries) 0 November 7th 07 10:26 PM
Command button text Steve W Excel Discussion (Misc queries) 1 May 4th 07 02:59 PM
Enable Command Button After Entering Text mikeg710 New Users to Excel 1 March 29th 07 04:12 PM
Is there a Wrap Text command button? Álvaro Excel Discussion (Misc queries) 5 December 1st 06 05:21 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"