ExcelBanter - xldialog question

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - xldialog question (https://www.excelbanter.com/excel-programming/378435-xldialog-question.html)

Gary Keramidas

xldialog question

is there any way top trap the cancel button when using
application.Dialogs(xlDialogPrinterSetup).Show?

--

Gary

Peter T

xldialog question

AFAIK all the dialogs return True (OK) or False (Cancel/Esc)

bOK = Application.Dialogs(xlDialogPrinterSetup).Show

Regards,
Peter T

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
is there any way top trap the cancel button when using
application.Dialogs(xlDialogPrinterSetup).Show?

--

Gary

Gary Keramidas

xldialog question

thanks, worked fine

--

Gary

"Peter T" <peter_t@discussions wrote in message
...
AFAIK all the dialogs return True (OK) or False (Cancel/Esc)

bOK = Application.Dialogs(xlDialogPrinterSetup).Show

Regards,
Peter T

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
is there any way top trap the cancel button when using
application.Dialogs(xlDialogPrinterSetup).Show?

--

Gary

All times are GMT +1. The time now is 10:29 AM.