fi.or.jp.de pretended :
Hi All,

In my excel, i have two userforms.

I have used code like this..
Problem is when i unload userform1 and load userform2, the userform2
is not visible until i click excel file.
I dont need to click excel file to activate userform2, how can i do
this automatically.

Userform1.show

Do...... something....


Unload Userform1

Userform2.show

do.. somethinng

unload userform2

In order to have your code continue to run while your userforms are
open you need to specify...

Userform1.Show vbModeless
'Do stuff while userform is open
Unload Userform1

I assume your users do not do anything with the userform other than
watch what your code does.

What stops users from closing it themselves?
What are you doing in your code while the userform is displayed?
How does the userform update while code is running?

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc