Solved

Excel VBA label text size growing uncontrollably!

Posted on 2010-09-21
8
955 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
Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

 
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

Independent Software Vendors: 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!

Question has a verified solution.

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

This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

710 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