Programmatic font face problem
"Matt Jensen" skrev i melding
...
I've fixed that and now it seems to be all good! Hooray!! Seems strange
though...
Well spotted, well done.
One problem that remains though (and is somewhat different from this
problem
but still relevant to it) is that, even though at the start of the proc I
have Application.Screenupdating = False & (pseudo code) cursor=hourglass
and
set it back to true and xldefault at the end of the proc respectively,
setting the *caption* of the label occurs after (it appears) that the proc
has finished (cursor goes back to default AND is visible onscreen), which
is
not good at all and what I would have thought screenupdating prevented
from
happening....? I thought DoEvents may have helped with this, but it
doesn't!
Should work. Make sure the order of operations is something like
Sub tester()
Application.Cursor = xlWait
Application.ScreenUpdating = False
'formatting here
DoEvents
Application.ScreenUpdating = True
Application.Cursor = xlDefault
End Sub
HTH. Best wishes Harald
|