M
Matthew Pearce
When building a VBA userform, whenever I click on the
properties box to
change the font size for e.g. a label or textbox caption,
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). The
third time I
tried this, I had 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.
This is the first userform in the spreadsheet. I normally
use Excel 97
at work - so this is why I haven't encountered this
problem before.
I am using Excel 2002 SP-2 on a Windows XP machine
running a Pentium 4
2.8 GHz processor with 1 Gb RAM.
Any solution to this would be gratefully received.
properties box to
change the font size for e.g. a label or textbox caption,
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). The
third time I
tried this, I had 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.
This is the first userform in the spreadsheet. I normally
use Excel 97
at work - so this is why I haven't encountered this
problem before.
I am using Excel 2002 SP-2 on a Windows XP machine
running a Pentium 4
2.8 GHz processor with 1 Gb RAM.
Any solution to this would be gratefully received.