userform

  • Thread starter Thread starter serge T
  • Start date Start date
S

serge T

Hello,
Could you explain why a userform.show instruction displays an empty dialog
box? I wanted to create a very simple userform to warn users they have to
wait, and this userform only contains a label "patience! macro running...".
Userform is opened modeless and it seems related.

Thanks for your help
 
Have you looked at simply putting in a messagebox? Something like:
alerts = MsgBox("Please be patient while critical functions are being
preformed.", vbCritical, "Please Wait")

or some variation of that...

As to why your userform is empty - the only reason i can think of for
that one is you didn't set your userform up correctly. There isn't
really enough information there for me to know, though.
 
Presuming that the userform is displayed in the same macro, it will take
over processing, and the macro waits until it shuts down.

Try having another macro that shows the form, then the primary macro is
called from the forms Activate event, not Initialize, and then shut the form
down after the primary macro finishes.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Thanks for your reply- I tried many things: removing this simple userform and
start again, add a button; except the blue label of the userform all appear
uniform white, except when the instruction is not modeless. I also create a
new module with a simple macro just to open that userform, then it displays
properly; could it be some interaction with application.statusbar
instructions?I keep on thinking to that exciting problem this evening, maybe
the light will finally get up...
 
To itsdedude,

I will forget that userform for that urgent application. But still I stay
puzzled that this simplest userform (I made complex ones elsewhere and this
one has only one label field) does not displays. The same userform is
displaying properly in a separate module to test it, but not in the real
application module; crazy!
anybody got an idea?
thanks
 
Back
Top