Modal/Modeless Forms

  • Thread starter Thread starter kirkm
  • Start date Start date
K

kirkm

Is there any way to have a form modeless in Excel 2002
but model in Excel 97.

I was playing with this

If Val(Application.Version) = 8 Then
frmLabel.Show
Else: frmLabel.Show vbModeless
End If

but the Else clause causes an error in Excel 97 (which
I can't trap out).

Thanks - Kirk
 
Hi kirkm,
You must use conditional compilation:

#If VBA6 Then
frmLabel.Show
#Else
frmLabel.Show vbModeless
#End If

MP
 
The correct procedure is the reverse:

#If VBA6 Then
frmLabel.Show vbModeless
#Else
frmLabel.Show
#End If

MP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Show Modeless Form 3
Can you check a show modal property 6
Set focus on controls of modeless form 4
Modeless dialog box appears twice on screen??? 1
Modeless UserForm 5
Mac Excel compile error method or data member not found 0
Bring my modeless userform to the foreground??? 8
Self closing "modal" window ? 4

Back
Top