Excel VBA label text size growing uncontrollably!

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
LVL 2
jacksonm1234Asked:
Who is Participating?
 
jacksonm1234Connect With a Mentor Author Commented:
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
 
sublimationCommented:
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
 
jacksonm1234Author Commented:
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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
jacksonm1234Author Commented:
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
 
SANTABABYCommented:
Could you please provide a sample?
0
 
jacksonm1234Author Commented:
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
 
SANTABABYCommented:
Tried but could not reproduce the problem. Attached is the workbook.
Book1.xlsx
0
 
jacksonm1234Author Commented:
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
All Courses

From novice to tech pro — start learning today.