Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 8 of 8

Thread: Keyboard Shortcut For Paste Special Values

  1. #1
    Join Date
    11th February 2007
    Posts
    14

    Keyboard Shortcut For Paste Special Values

    Is there a short-cut key sequence for paste special value short of:

    Alt+E+S+V

    or

    Writing a subroutine in Personal.xls and giving it a shortcut key like:
    VB:
    Sub PasteValues () 
         ' Keyboard Shortcut: Ctrl+Shift+V
         
        Selection.Formula=Selection.Value 
         
    End Sub 
    
    
    Kind-of a lame request but it would help a client of mine tremendously...it's a long story as to why they are looking for a shorter way (that I really don't agree with anyway) but I thought I'd ask.

    Thanks.
    Last edited by royUK; March 4th, 2007 at 21:35.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    26th January 2003
    Location
    Derbyshire,UK
    Posts
    18,345

    Re: Keyboard Shortcut For Paste Special Values

    I suggest that you read the Forum Rules that you agreed to. You neglected to use Code tags despite being reminded on the page from which you asked this question.

    I have added them this time, but future posts may well be deleted for non-compliance with the Rules
    Hope that Helps

    Roy

    For free Excel tools & articles visit my web site

    If I have helped you and you feel like putting your hand in your pocket please make a donation to Children in Need

    RoyUK's Web Site

    royUK's Database Form

    Where to paste code from the Forum

    About me.

  3. #3
    Join Date
    26th January 2003
    Location
    Derbyshire,UK
    Posts
    18,345

    Re: Keyboard Shortcut For Paste Special Values

    Something like this, assign a keyboard shortcut to suit

    VB:
    Public Sub ShowPasteSpecial() 
        If Application.CutCopyMode <> False Then 
            On Error Resume Next 
            Application.Dialogs(xlDialogPasteSpecial).Show 
        Else 
            MsgBox "The Clipboard is empty.", vbInformation, "PasteSpecial" 
        End If 
    End Sub 
    
    
    Last edited by royUK; March 4th, 2007 at 21:40.
    Hope that Helps

    Roy

    For free Excel tools & articles visit my web site

    If I have helped you and you feel like putting your hand in your pocket please make a donation to Children in Need

    RoyUK's Web Site

    royUK's Database Form

    Where to paste code from the Forum

    About me.

  4. #4
    Join Date
    11th February 2007
    Posts
    14

    Re: Keyboard Shortcut For Paste Special Values

    Thanks for bailing me out on that one!



    But without a subroutine...is there anything that is built in?

    Thanks.

    PS. I'd like to point out your error message in that title box still says "DELKETED" and is still in all caps...violations of your rules too. Just an observation. Thanks for fixing my error though.

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    26th January 2003
    Location
    Derbyshire,UK
    Posts
    18,345

    Re: Keyboard Shortcut For Paste Special Values

    Quote Originally Posted by Source
    Thanks for bailing me out on that one!



    But without a subroutine...is there anything that is built in?

    Thanks.

    PS. I'd like to point out your error message in that title box still says "DELKETED" and is still in all caps...violations of your rules too. Just an observation. Thanks for fixing my error though.
    That's Dave's department & he is very busy with more important things at the moment
    Hope that Helps

    Roy

    For free Excel tools & articles visit my web site

    If I have helped you and you feel like putting your hand in your pocket please make a donation to Children in Need

    RoyUK's Web Site

    royUK's Database Form

    Where to paste code from the Forum

    About me.

  6. #6
    Join Date
    11th February 2007
    Posts
    14

    Re: Keyboard Shortcut For Paste Special Values

    I can wait. As I said it is a lame request. I am going to log off though. I'll check back my tomorrow (later today its 5:11 am here).
    Thanks!
    Last edited by Source; March 4th, 2007 at 22:12.

    Excel Video Tutorials / Excel Dashboards Reports


  7. #7
    Join Date
    26th January 2003
    Location
    Derbyshire,UK
    Posts
    18,345

    Re: Keyboard Shortcut For Paste Special Values

    I don't know how much shorter they need.

    You could add it to the right click menu, but that would really mean an addin, or put it in a Worksheet event eg
    VB:
    Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) 
        If Application.CutCopyMode <> False Then 
            On Error Resume Next 
            Application.Dialogs(xlDialogPasteSpecial).Show 
        Else 
            MsgBox "The Clipboard is empty.", vbInformation, "PasteSpecial" 
        End If 
         
    End Sub 
    
    
    Hope that Helps

    Roy

    For free Excel tools & articles visit my web site

    If I have helped you and you feel like putting your hand in your pocket please make a donation to Children in Need

    RoyUK's Web Site

    royUK's Database Form

    Where to paste code from the Forum

    About me.

  8. #8
    Join Date
    12th September 2006
    Location
    The Great State of Texas
    Posts
    4,323

    Re: Keyboard Shortcut For Paste Special Values

    I use Paste Values a lot -- and so customized the standard toolbar to include the button.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Keyboard shortcut for Paste Options button
    By kwsmith in forum EXCEL HELP
    Replies: 8
    Last Post: August 19th, 2013, 03:07
  2. VBA: Paste Special (Values)
    By VBAnewbie in forum EXCEL HELP
    Replies: 5
    Last Post: May 12th, 2012, 07:17
  3. Paste Special Values
    By junll in forum EXCEL HELP
    Replies: 8
    Last Post: April 24th, 2007, 11:04
  4. Paste Special Values
    By ZeroMan001 in forum EXCEL HELP
    Replies: 1
    Last Post: January 17th, 2007, 10:38
  5. paste Special Values.
    By countryfan_nt in forum EXCEL HELP
    Replies: 3
    Last Post: September 17th, 2005, 19:40

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno