VBA show a Dialog Box in another Workbook

[ibbo]

Hello,

Is it possible to display a dialog sheet in a different workbook without transferring the dialog sheet to the second workbook?

I am running the code from "Book1":
Application.Run ("'Tray Stock 2.xlsm'!showmsgbox")

showmsgbox code appears as:
Sheets("Sheet1").Select
With DialogSheets("Dialog1")
DialogSheets("Dialog1").Show

The issue I have is that the dialog box shows in Tray Stock 2 workbook and not book1. When I have specified Workbooks("Book1").activate before selecting the worksheet I get error "subscript out of range".

running the code from "Book1" works like a dream, the only problem is the dialog sheet displaying in the wrong workbook.

Any help would be appreciated.

Best Regards,
Jonathan

 

[nightcrawler23]

I dont have much idea about dialogue sheets. doees it have a property of ShowModal like a userform. Try playing with this property.

 

[ibbo]

Thanks for the speedy response.

I will have a play with userforms/modal property, however as the second workbook is on a seperate computer on a shared harddrive within the same network I am not sure where to start.

I will keep you posted if I find a solution.

Thanks again

 

[ibbo]

your solution worked! The issue was that the dialog sheet is based within "Tray Stock 2", whereas if I use a userform (attached to Tray Stock 2) in Vb editor I can display the popup on a different workbook by running the macro from Book1, as long as both workbooks are open.

There will probably be a way to do the same using a dialog sheet, however this solution worked for me.

Thank you.