+ Reply to Thread
Results 1 to 4 of 4

Button Text Gets Smaller When Button Clicked On

  1. #1
    Registered User
    Join Date
    08-27-2008
    Location
    United States
    Posts
    45

    Button Text Gets Smaller When Button Clicked On

    Hello,

    I have a button on my spreadsheet which is exhibiting strange characteristics. It runs a sub, and every time I run the sub, it causes the text on the button to get smaller. This continues until the button text is no longer visible.

    Now, if I resize the button in design mode, the text springs back to the right size. I have no idea why this is happening because as far as I can tell, the button has identical characteristics to all the other buttons in my sheet which don't do that.

    Previously it instead would get larger and larger as I clicked on it and something I did (I do not know what) changed that to make the text to get smaller and smaller.

    I'm highly confused right now XD I don't see any settings different about it than my other buttons.

    Thanks in advance,
    GoogleBot
    Last edited by googlebot; 09-18-2008 at 09:21 AM. Reason: wording

  2. #2
    Forum Expert Kenneth Hobson's Avatar
    Join Date
    02-05-2007
    Location
    Tecumseh, OK
    MS-Off Ver
    Office 365, Win10Home
    Posts
    2,573
    Typically, this kind of thing happens when you delete rows. To avoid this problem, right click the button in Design Mode, Format Control..., Properties, Don't move or size with cells, OK.

  3. #3
    Registered User
    Join Date
    09-06-2009
    Location
    Norway
    MS-Off Ver
    Excel 2003
    Posts
    1

    Question Re: Button Text Gets Smaller When Button Clicked On

    hi, I've got the same problem, although I don't delete any rows or columns in the code. Have tried the method above, but it doesn't work. Any other tips?

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Button Text Gets Smaller When Button Clicked On

    Welcome to the forum.

    Please take a few minutes to read the forum rules, and then start your own thread.

    Thanks.
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. changing import text default from general to text
    By shoshanako in forum Excel General
    Replies: 3
    Last Post: 02-17-2012, 08:22 AM
  2. Manipulating Macro Button in Standard Toolbar
    By DCSwearingen in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-02-2008, 11:57 AM
  3. Double Clicking a Command Button
    By NewExcelUser in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-09-2007, 01:37 AM
  4. Finding Text in a Text Box
    By xcelentform in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 12-15-2006, 12:00 PM
  5. Preserving text format/style - concatenate function
    By michaelc in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-11-2006, 12:51 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1