Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 56
Default Command Button Text Cut Off

In my command buttons, the bottom edge of the text is cut off. This
is true for all letters that go "below the line", e.g. g, p, q
How can I format the command button so that the text will display
completely?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 259
Default Command Button Text Cut Off

Hi Jason

You could try a different font & or reducing the size of it; Or you could
try making the command button larger.

HTH
Mick


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 157
Default Command Button Text Cut Off

Hi Jasont Ferrell
I presume your buttons are from the 'Control Toolbox", right click and select
Properties, reduce the size of the font or you can enlarge the buttons.
If your buttons are from the "Form Toolbar", right click "Format Control" you
can change the size of the font or in the Alignment Tab you can select
"Automatic size'.
HTH
Cimjet

"jasontferrell" wrote in message
...
In my command buttons, the bottom edge of the text is cut off. This
is true for all letters that go "below the line", e.g. g, p, q
How can I format the command button so that the text will display
completely?


  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 56
Default Command Button Text Cut Off

I'm using the Control Toolbox. If I choose Arial, 12pt, it doesn't
matter how large the box is, it always cuts off a g. If I go down to
10pt, it works ok. Any ideas how I can use 12pt?
My text is "(1) Get Product Cogs and Load". My box is 161.25 high and
495.75 wide.


On May 26, 9:13*am, "Cimjet" wrote:
Hi Jasont Ferrell
I presume your buttons are from the 'Control Toolbox", right click and select
Properties, reduce the size of the font or you can enlarge the buttons.
If your buttons are from the "Form Toolbar", right click "Format Control" you
can change the size of the font or in the Alignment Tab you can select
"Automatic size'.
HTH
Cimjet

"jasontferrell" wrote in message

...



In my command buttons, the bottom edge of the text is cut off. *This
is true for all letters that go "below the line", e.g. g, p, q
How can I format the command button so that the text will display
completely?- Hide quoted text -


- Show quoted text -


  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 157
Default Command Button Text Cut Off

Hi Jasont
Change your font, try "Times New Roman"
HTH
Cimjet
"jasontferrell" wrote in message
...
I'm using the Control Toolbox. If I choose Arial, 12pt, it doesn't
matter how large the box is, it always cuts off a g. If I go down to
10pt, it works ok. Any ideas how I can use 12pt?
My text is "(1) Get Product Cogs and Load". My box is 161.25 high and
495.75 wide.


On May 26, 9:13 am, "Cimjet" wrote:
Hi Jasont Ferrell
I presume your buttons are from the 'Control Toolbox", right click and select
Properties, reduce the size of the font or you can enlarge the buttons.
If your buttons are from the "Form Toolbar", right click "Format Control" you
can change the size of the font or in the Alignment Tab you can select
"Automatic size'.
HTH
Cimjet

"jasontferrell" wrote in message

...



In my command buttons, the bottom edge of the text is cut off. This
is true for all letters that go "below the line", e.g. g, p, q
How can I format the command button so that the text will display
completely?- Hide quoted text -


- Show quoted text -




  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 56
Default Command Button Text Cut Off

That works!
  #7   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 157
Default Command Button Text Cut Off

Glad to see it working.
Cimjet
"jasontferrell" wrote in message
...
That works!


  #8   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,514
Default Command Button Text Cut Off

jasontferrell brought next idea :
In my command buttons, the bottom edge of the text is cut off. This
is true for all letters that go "below the line", e.g. g, p, q
How can I format the command button so that the text will display
completely?


Increase its height OR decrease its font size via the Properties.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc


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 Text gets smaller Andy Excel Programming 2 January 15th 10 12:06 AM
Align Text in Command button Wanna Learn Excel Discussion (Misc queries) 2 October 26th 08 12:22 PM
Need to Add Text to Control Text Box via Command Button code BJ Excel Programming 1 September 19th 08 06:16 PM
Command button text Steve W Excel Discussion (Misc queries) 1 May 4th 07 02:59 PM
Bug: Command Button Text Size Changes charlie oppenheimer Excel Programming 3 August 22nd 05 12:06 AM


All times are GMT +1. The time now is 10:17 AM.

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"