xlDialogPasteSpecial

Hot Topic

opc
How to judge a field's value is already exist while inputing it?
Matrix syntax
Update existing chart ranges in VBA
Excel Chart: How to change chart data source formula when object "Series.Formula" is too short?
Excel Advanced filter critera Question...
installling business scorecard manager 2005
Using arrows to select in drop down list in access
Cells
opc

Microsoft ISV

Problems installing Business Scorecard Manager
Excel2003 VBA - Application.quit not stopping code
document title
When sending a worksheet to the USB port …
Action Pack Question
For Next stops at 16
How To Open A File On Another Computer On A Home Network
Wireless Information into Excel Spreadsheet
Error while editing Tasks\Announcements etc. in Sharepoint 2007
MS Access User Defined Permissions

xlDialogPasteSpecial

Hi friends,

I can open PasteSpecial Dialog box with the Help of Following Code.

Application.Dialogs(xlDialogPasteSpecial).Show.

This will show the Dialog Box. But I want to Know what User Options does User selects in the PasteSpecial Box.

Is there any Way

Thanks




Answer this question

xlDialogPasteSpecial

  • Espo4Life

    The dialogs in Excel are not particularly interactive with VBA. The xlDialogSaveAs returns true if the file is actually saved and false if not, but in general you don't get much information returned from the dialogs.

    You might have to create your own userform styled after the Paste Special dialog, which then returns the user selections to the code, and then your code applies the appropriate paste special option itself.

    - Jon
    -------
    Jon Peltier, Microsoft Excel MVP
    Tutorials and Custom Solutions
    http://PeltierTech.com
    _______



  • xlDialogPasteSpecial
Answer this question