ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   HELP - simple VBA property causes Excel to crash (https://www.excelbanter.com/excel-programming/280431-help-simple-vba-property-causes-excel-crash.html)

No Name

HELP - simple VBA property causes Excel to crash
 
I am running Excel 2002 SP-2 on a Windows XP machine
running a Pentium 4 2.8 GHz processor with 1 Gb RAM.

After adding e.g. a label to a brand new VBA userform in
a new workbook, I click on the ellipsis against the font
property in the properties window to change the font size
and Excel starts another process (i.e. I see another
Excel process on the Windows task bar) and consumes close
to 100 % of my CPU.

The first couple of times I tried this, Excel eventually
brought up the font properties window (after more than a
minute). Usually I have to crash Excel via Windows Task
Manager.

At the time of trying to change the font properties, the
font was set to use the default Tahoma font.

I normally use Excel 97 at work - so this is why I
haven't encountered this problem before.

Any solution to this would be gratefully received.



All times are GMT +1. The time now is 12:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com