View Single Post
 
Old 02-10-2017, 03:36 PM
AXbean AXbean is offline Windows 10 Office 2013
Novice
 
Join Date: Feb 2017
Posts: 5
AXbean is on a distinguished road
Default Copy text and paste using Enter key

Hello all, first post. I created a macro in Excel in which a user can make a selection, click on a button (which runs the COPY command), click on a new location, and press ENTER to paste the copied selection. Is there a similar function (VBA) for Word? The same code does not work.
Here is the Excel code:
Code:
Sub CopySel(control As IRibbonControl)
Selection.Copy
ActiveSheet.Paste
End Sub
Thanks in advance,
Robert
Reply With Quote