Solved: VBA Shortcut - Paste Values, Formats, Both
Hi all...
I rarely do a straight Ctrl+C, Ctrl+V. I either paste values, or format...or both.
Is there any VBA addin (preferable as I can then turn it off) or code available so that I can create keyboard shortcuts for these 3 distinct scenarios. Maybe use some 'F' keys that aren't needed. Or...
Ctrl+Shift+? = Paste Value
Ctrl+Shift+? = Paste Formats
Ctrl+Shift+? = Paste All (Value + Format
Last edited by theta; 04-12-2012 at 04:01 AM.
Yes, just lookup OnKey in VBA help.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
That's great, thank you
Also found the keyboard shortcuts (for ref of any googlers coming across this thread) :
Alt+E > S > V (for Values) or F (for Formulas) or T (for Formats)
This refers to the old Excel 2003 keyboard shortcut method which is initalised when typing Alt+E
Posting Permissions
Reply With Quote
