How to do a msgbox form without buttons

[denis60]

hI!
I'm doing a program who will run for a long time.
I woud like to use a form without buttons to show each step of my program.
I want to control it all the time my vba code work.
But all i know of forms is when it's showed it keep control t'll it's close and it's not what i want.

Please help me

 

[kylua]

Put your code into the form activate event for the form concerned.

And what code are you doing that takes so long out of interest.

 

[denis60]

I treat a 12 M files to transform it and filter it in record, ready to input ot Excel.
I match each record with people who suppose to work with.
And i highlight (with color) values higher than (10,100,500)
etc.

If i understand it could be like this:

Private Sub UserForm_Initialize()

dim xxx

userform1.label1.caption = "xxxxxxx"
userform1.show ???

End Sub

if it's like that the form after the show command take control until the X is press on the form!!

 

[xlbo]

Pseudo code

Sub DoLongSub()
start code
frmName1.show
more code
frmName1.hide
frmName2.show
more code
frmName2.hide
end sub

The main thing you have to watch out for is that certain calls may fall over - like activesheet for example. Also, you'll have to explicitly reference everything

May also be worth taking a look here:

http://j-walk.com/ss/excel/tips/tip34.htm

Not quite what you asked for but may be a simpler way of doing it

HTH
Rgds
~Geoff~

 

[denis60]

Thanks folk and xlbo(Geoff) i found my answer with tip34.htm and it work good.
When i need help i now where to find best people. (Excuse my english)