Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Short Cut Key???

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    82
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi everyone,,

    Any shortcut key for Paste Special (Value)
    or else can I create a short cut key for it?

    Many thanks

  2. #2
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi

    You will need to create one, this should do the trick.

    Sub MakeValueOnly()
    Selection=Selection.Value
    End sub




  3. #3
    Board Regular
    Join Date
    Mar 2002
    Posts
    82
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    ANY step to step guidance? as I am not good at macro...

  4. #4
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Sure, Hold down the Alt key and push F11. Go to Insert>Module and then paste in the code. Hold down Alt and push Q Now again hold down the Alt key and push F8, select the macro name then click "Options" and assign a shortcut key.




  5. #5
    Board Regular
    Join Date
    Mar 2002
    Posts
    82
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks but I try to copy a cell with formula and press Ctrl+.. ,, i doesn't give me the value..

    I guess it only works when transforming the formula into value..

    Is that any further suggestion?

  6. #6
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Oh, in that case use this


    Sub MakeValueOnly()
    On Error GoTo EmptyClipB
    Selection.PasteSpecial xlValues
    Exit Sub
    EmptyClipB:
    MsgBox "Clipboard Empty"
    End Sub

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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