Modeless property
 

Hi..

This is driving me crazy...What modifications are required to the code below make my dialog box modeless..

Sub SHOWDIALOG1(
DialogSheets("DIALOG1").Sho
End Su

Thanks in advanc

Gordon...

Modeless property
 

Hi Gordon,

Sub SHOWDIALOG1()
DialogSheets("DIALOG1").Show
End Sub


Sub SHOWDIALOG1()
DialogSheets("DIALOG1").Show vbModeless
End Sub

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

Modeless property
 

Hi Gordon,

Sub SHOWDIALOG1()
DialogSheets("DIALOG1").Show
End Sub


Silly me. Forget my previous reply. A dialogsheet cannot be shown
modeless, you must use a userform (In the VBE insert, userform) for
that.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

Modeless property
 

Stephen Bullen would disagree. Visit his site
(http://www.bmsltd.co.uk/Excel/Default.htm) and download
ModelessForm.zip.

--

Jan Karel Pieterse wrote in message ...
Hi Gordon,

Sub SHOWDIALOG1()
DialogSheets("DIALOG1").Show
End Sub


Silly me. Forget my previous reply. A dialogsheet cannot be shown
modeless, you must use a userform (In the VBE insert, userform) for
that.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

Modeless property
 

Hi Onedaywhen,

Stephen Bullen would disagree.


I agree. <g

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com