Modeless property

[Guest]

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

 

[Jan Karel Pieterse]

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

 

[Jan Karel Pieterse]

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

 

[onedaywhen]

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

--

 

[Jan Karel Pieterse]

Hi Onedaywhen,

Stephen Bullen would disagree.

I agree. <g>

Regards,

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