View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Henry[_4_] Henry[_4_] is offline
external usenet poster
 
Posts: 72
Default Bring up a UserForm to the front

Jens,

Some code would have been helpful.
I've looked again at the code in your website and suggest you try putting
the
..Visible = True before the .ScreenUpdating = False line

The way you've got it, you turn off screen updating and then try to make
word visible.
As the screen updating is turned off, this has no (visible) effect until you
turn screen updating on again.

With appWord.Application
.Visible = True
If CHECK Then .ScreenUpdating = True Else .ScreenUpdating = False

HTH
Henry


"Jens 'Kluesi' Kluesener" wrote in message
...
Hi

I create a word document from Excel. If I do this whil word is running my
form is on the top of the screen. If word is not running the form is not

at
the top of the screen when word starts. How can I now bring up the form to
the front?

Many Thanks

Jens