Announcement

Collapse
No announcement yet.

Keyboard Shortcut For Paste Special Values

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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:
    Code:
    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, 22:35.

  • #2
    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

    New users should read the Forum Rules before posting

    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.

    Comment


    • #3
      Re: Keyboard Shortcut For Paste Special Values

      Something like this, assign a keyboard shortcut to suit

      Code:
      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, 22:40.
      Hope that Helps

      Roy

      New users should read the Forum Rules before posting

      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.

      Comment


      • #4
        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.

        Comment


        • #5
          Re: Keyboard Shortcut For Paste Special Values

          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

          New users should read the Forum Rules before posting

          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.

          Comment


          • #6
            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, 23:12.

            Comment


            • #7
              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
              Code:
              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

              New users should read the Forum Rules before posting

              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.

              Comment


              • #8
                Re: Keyboard Shortcut For Paste Special Values

                I use Paste Values a lot -- and so customized the standard toolbar to include the button.
                Entia non sunt multiplicanda sine necessitate.

                Comment

                Working...
                X