Solved

Excel VBA label text size growing uncontrollably!

Posted on 2010-09-21
8
931 Views
Last Modified: 2013-11-25
Interesting problem --

I've got an Excel spreadsheet that I created a label on -- this is not a userform. The label simply says "month".  Whenever I click on the label, the text size grows. If I click off of the label, and then click it again, the text size grows again.  Eventually the text gets so big it won't fit in the label.

If I want to reset the text size, I just have to resize the label just a tiny bit and the text size will return to normal.  Has anyone ever experienced this before? It's very strange.

Attached below are the properties of the label.  As far as I can tell, there is no VB that fires when the label is clicked.  Properties of the label
0
Comment
Question by:jacksonm1234
  • 5
  • 2
8 Comments
 
LVL 4

Expert Comment

by:sublimation
ID: 33725137
Delete the Label and have a new one...Does it still happen.

Can you replicate it in a fresh workbook (i.e. add alabe and click on it)?

0
 
LVL 2

Author Comment

by:jacksonm1234
ID: 33725220
I deleted the label and added a new one -- similar result.  I was also able to replicated it in a brand new workbook.
But I also noticed something else interesting that I maybe didn't see before. Each time I click on the label, the label size appears to shrink!
You also may be able to replicate this -- stick an Activex Label on a sheet, exit design view, and keep clicking on it.
0
 
LVL 2

Author Comment

by:jacksonm1234
ID: 33725339
Another interesting thing -- When I click on/off design view, all of my activex listboxes gradually shrink in size. If I keep clicking the design view button, they will eventually shring to almost nothing! Crazy.
0
 
LVL 10

Expert Comment

by:SANTABABY
ID: 33726748
Could you please provide a sample?
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 2

Author Comment

by:jacksonm1234
ID: 33727497
I am unable to upload a spreadsheet to show you due to my company policy, but I can give you the steps. They are very easy.   In Excel 2007:
  • Create a new worksheet
  • Go to the "Developer" tab
  • Choose the dropdown that says "Insert" (has a hammer and wrench on it)
  • Choose an ActiveX Label (looks like a big 'A')
  • Draw one on the spreadsheet, anywhere
  • Exit design view by clicking on the design mode button (next to the insert)
  • Click on the label
  • Click off the label
  • Click on the label
  • Click off the label
  • etc.
As you click on/off the label, one of two things will happen: 1) the text will slowly get bigger, or 2) the label size will slowly shrink with repeated clicks.
Please someone give it a shot!
0
 
LVL 10

Expert Comment

by:SANTABABY
ID: 33731835
Tried but could not reproduce the problem. Attached is the workbook.
Book1.xlsx
0
 
LVL 2

Author Comment

by:jacksonm1234
ID: 33734283
Sigh.  When I open your woorkbook and click on and off of your label 10-20 times, the label size slowly shrinks.  I don't know why you can't see it but I can.  I wish i had a way to take a video...oh well.
If no one else can reproduce it I'll have to close the question. Very sad.
0
 
LVL 2

Accepted Solution

by:
jacksonm1234 earned 0 total points
ID: 33734346
The behavior has stopped.  All I did was completely close out of all instances of Excel, and try again.  Everything appears to be behaving appropriately now.
Sorry to waste everyone's time.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Over the years I have built up my own little library of code snippets that I refer to when programming or writing a script.  Many of these have come from the web or adaptations from snippets I find on the Web.  Periodically I add to them when I come…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

896 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now