Ahh - unfortunately I'll have to wait until the IT department get around to purchasing XL2000. Thanks for your help though, I'll keep it in mind.
Regards,
Peter
sounds like a good excuse to upgrade if the bigwigs want it that way
There are other ways around getting what you want?
If I understand your Q, you are after a userform
to display while running your code ?? similar to
having a splash screen with some msg on it.
If so then there are a number of ways to do this
1) If you do want a userform then your code should
be in the userform.initialise routine.
2) You can create on the fly a textbox with a msg
3) Create your image or textbox msg and just use
its visible property to display when required.
4) you can via userforms creat progressbars to
display
have a look @ this site formore info
http://edc.bizhosting.com/english/index.htm
If you require examples I would be happy to show
you
Ivan
Peter,
If you have XL97, there is no hope, but in XL2000, you can show a UserForm "Modeless", instead of Modal. Here is the proper syntax:
UserForm1.Show Modeless
Hope this helps, let me know.
Ryan