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...

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

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

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

Hi Onedaywhen,

Stephen Bullen would disagree.


I agree. <g

Regards,

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