Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,494
Default xldialog question

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

--


Gary



  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,600
Default 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





  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,494
Default 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







Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Capture user input into xldialog print vpanang Excel Programming 3 April 27th 06 09:45 PM
Value From xlDialog Brad Excel Programming 1 June 1st 05 12:07 AM
Append code to a xlDialog Kent Smith Excel Programming 1 February 23rd 05 02:24 AM
XLDialog Printer Setup Ron Crapo Excel Programming 2 August 27th 04 05:40 PM
xldialog Philipp Oberleitner[_2_] Excel Programming 5 July 9th 04 06:39 PM


All times are GMT +1. The time now is 12:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"