Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Excel VBA label text size growing uncontrollably!

Posted on 2010-09-21
8
Medium Priority
?
969 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

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

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
With User Account Control (UAC) enabled in Windows 7, one needs to open an elevated Command Prompt in order to run scripts under administrative privileges. Although the elevated Command Prompt accomplishes the task, the question How to run as script…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

688 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