Excel 2010 Cell Selection Macro

Question

So I'm floored that there is not a hotkey to do this. I went on Microsoft's site to check the Excel hotkeys and there isn't one.

All I want to do is have a hotkey that copies the contents of a cell that I have currently selected. I don't want to use my mouse at all. Is this possible? The only solution that Microsoft provides is:

Hit F2 to edit the contents of the selected cell
Select text with Shift+Arrow (Not Ctrl+A mind you, this does not work in a cell)
Hit Ctrl+X or Ctrl+C to copy the value.

Microsoft Description

Why is there not hotkey for this? Can one be made? It would make my life a lot easier.

Still, doesn't this seem like something that should be automated? When I just copy the cell sometimes I'm not pasting in a place that I can just paste plain text, so I get the whole cell. — ToastyMallows, Jun 07 '12 at 15:18
you want to only see the text it it were a formula, or include the "=" as well? — datatoo, Jun 07 '12 at 16:58
Just copy everything that is in the cell. The answer below does exactly what I want. — ToastyMallows, Jun 08 '12 at 13:22

score 2 · Accepted Answer · answered Jun 07 '12 at 17:23

2

You will have to assign the macro to your own hotkey but this will add the ActiveCell text to the clipboard. Add a reference to the Microsoft Forms 2.0 Object Library

Sub hotKeyCopy()
Dim DataObj As New MSForms.DataObject
Dim copyText As String
copyText = ActiveCell.Text
DataObj.SetText copyText
DataObj.PutInClipboard
End Sub

answered Jun 07 '12 at 17:23

datatoo

2,019
2
21
28

Nice! Thank you so much. For anyone that is curious on how to add a reference to the Microsoft Forms 2.0 Object Library, in the Microsoft VB for Applications window when making the macro, go to Tools -> References then find Microsoft Forms 2.0 Object Library in the list. If its not there, click Browse... and go to c:\windows\system32\FM20.DLL. – ToastyMallows Jun 08 '12 at 13:20
Also, if you can't find it on the list, adding a form to a workbook will automatically set the reference, and you can then remove the form – datatoo Jun 08 '12 at 15:33

Excel 2010 Cell Selection Macro

1 Answers1