ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to change Titlel of Dialog Box? (https://www.excelbanter.com/excel-programming/353238-how-change-titlel-dialog-box.html)

Naman.Patel[_2_]

How to change Titlel of Dialog Box?
 
I am using this code to show dialog box and I want to change title of dialog
box from "Open" to "Xyz"

Set fd = Application.Dialogs(xlDialogOpen)
fd.show

Norman Jones

How to change Titlel of Dialog Box?
 
Hi Naman,

Look at the GetOpenFilename method in VBA help.


---
Regards,
Norman



"Naman.Patel" wrote in message
...
I am using this code to show dialog box and I want to change title of
dialog
box from "Open" to "Xyz"

Set fd = Application.Dialogs(xlDialogOpen)
fd.show





All times are GMT +1. The time now is 04:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com