Can't show an UserForm (Frm.Show False does not work) 
Author Message
 Can't show an UserForm (Frm.Show False does not work)

I'd like to show a 'Please wait message' during the Excel macro does
something in the background.

  dim frm as frmWaitForm
  set frm = new frmWaitForm
  load frm
  frm.show false                              'false parameter makes
form display non-modally, i.e.do not wait for OK button to be pushed.
[long running process here.]
  frm.hide
  unload frm
  set frm = nothing

Does someone know why I get an error in the line
  frm.show false

Compile error: Wrong number of arguments or invalid property assignment.

Does someone have any idea what I'm doing wrong?

Any help is very appreciated
Stefan



Wed, 18 Jun 1902 08:00:00 GMT  
 Can't show an UserForm (Frm.Show False does not work)
Hi Stephan

<< frm.show false >>
will work only in Office 2000.

However for your objective (as I understand it) you can simply have:

----------------
Sub MyMacro()
'...long procedure doing lots of funcy things
End Sub

Sub startMacro()
Userform1.Show
End Sub
-----------------

and in the userform:

Private Sub Userform_Activate()
DoEvents  'To allow it paint itself first
Call MyMacro
End Sub
------------------

HTH
Stratos

Quote:

> I'd like to show a 'Please wait message' during the Excel macro does
> something in the background.

>   dim frm as frmWaitForm
>   set frm = new frmWaitForm
>   load frm
>   frm.show false                              'false parameter makes
> form display non-modally, i.e.do not wait for OK button to be pushed.
> [long running process here.]
>   frm.hide
>   unload frm
>   set frm = nothing

> Does someone know why I get an error in the line
>   frm.show false

> Compile error: Wrong number of arguments or invalid property assignment.

> Does someone have any idea what I'm doing wrong?

> Any help is very appreciated
> Stefan



Wed, 18 Jun 1902 08:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Userform.show method not working in saved doc

2. Userform.show method not working in saved doc

3. rstOrder.nomatch is showing True when it should show False

4. Show All (show/hide) not working in Word 2002

5. OE 6 Picture Slide Show Not Present and Graphic Attachments Aren't Shown

6. Subreport not printing but showing in preview, or not showing at all

7. Auto-preview pane does not show up...Layout won't work either

8. Add new Rec's to a Sub frm when Allow Additions = False

9. UserForm not showing without alt-tab

10. Variable(s) Reset by Showing 2nd UserForm on top 1st UserForm


 
Powered by phpBB® Forum Software © phpBB Group