LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 34
Default copy paste with key shortcuts

Ok, sorry if I wasn't gettig it before. I don't believe you can do that in
one module. You'll have to have two macros, with two short-cuts. Or you
could experiment, write 2 macros, then copy code from one Macro to the other,
and see if the short cuts work.

"pm" wrote:

Kou Vang wrote:

You will have the option of running the Macro with a Ctrl + keyboard key.
So, the answer is yes. (of course you would not be allowed standard short
cut options of ctrl+c or ctrl+v)


i know that, but is a possibility of operating macro with shortcuts.

ie. when pressed ctrl+shift+v then active range select and copy
when pressed ctrl+shift+c the selected range paste with transposition and
horizontal flip

both shortcuts in one module...

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Keyboard Shortcuts for Paste Special Values and Formats Scott Excel Discussion (Misc queries) 3 May 20th 23 11:41 AM
Excel should have keyboard shortcuts for paste value/format aricshoe Setting up and Configuration of Excel 1 February 5th 06 02:32 AM
Excel should have keyboard shortcuts for paste value/format Pancake Batter Setting up and Configuration of Excel 0 February 4th 06 01:02 PM
Excel cut/Paste Problem: Year changes after data is copy and paste Asif Excel Discussion (Misc queries) 2 December 9th 05 05:16 PM
Copy and Paste macro needs to paste to a changing cell reference loulou Excel Programming 0 February 24th 05 10:29 AM


All times are GMT +1. The time now is 02:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"