PC Review


Reply
Thread Tools Rate Thread

BuiltIn dialogs value

 
 
Vitalya
Guest
Posts: n/a
 
      24th Jun 2009

Hi all,
How can I check what button user press in builtIn dialog?
For example I want to check If user press 'Cancel' button in the Print dialog.
In MSWord i implement DocumentBeforePrint function and call:
long buttonValue = pDialog->Display(). If buttonValue == 0 - user press
"Cancel".
How can I do it in Excel.
 
Reply With Quote
 
 
 
 
JLGWhiz
Guest
Posts: n/a
 
      24th Jun 2009

Excel is not so kind when using VBA to test the "Cancel" value. It could be
"" or it could be "False" depending on the dialog box you are testing. If
believe that in general you could use"

aVar = <DialogBoxValue>
If aVar = "" Or aVar = "False" Then
'result
End If



"Vitalya" <(E-Mail Removed)> wrote in message
news:FAE20103-39AE-42C2-B032-(E-Mail Removed)...
> Hi all,
> How can I check what button user press in builtIn dialog?
> For example I want to check If user press 'Cancel' button in the Print
> dialog.
> In MSWord i implement DocumentBeforePrint function and call:
> long buttonValue = pDialog->Display(). If buttonValue == 0 - user press
> "Cancel".
> How can I do it in Excel.



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 builtin dialogs =?Utf-8?B?ZGVuaXM=?= Microsoft Excel Programming 0 15th Jun 2007 09:42 AM
second hand builtin XP mike gee Windows XP New Users 3 17th Jul 2004 03:19 PM
Builtin Jairo Patiņo Microsoft Windows 2000 Group Policy 1 17th Feb 2004 09:58 PM
How to use builtin functions ~~Alan~~ Microsoft Access Getting Started 9 25th Nov 2003 05:35 PM
Using builtin Messenger Ser Sam Windows XP Networking 0 11th Jul 2003 12:45 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:56 AM.