Improve company productivity with a Business Account.Sign Up

x
?
Solved

Excel VBA label text size growing uncontrollably!

Posted on 2010-09-21
8
Medium Priority
?
974 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
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
LVL 10

Expert Comment

by:SANTABABY
ID: 33726748
Could you please provide a sample?
0
 
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

What to do if a split doesn't fit? Or a bunch of invoice lines must be rounded while the sum must match a total? It takes a little, but - when done - it is extremely easy to implement.
Usually, rounding is performed by some power of 10 - to thousands, hundreds, tens, or integer - or to one, two, or more decimals. But rounding can also be done to a power of two, say, 16 or 64, or 1/32 or 1/1024, even for extreme values.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

595 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