Solved: VBA Shortcut - Paste Values, Formats, Both

[theta]

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

[Bob Phillips]

Yes, just lookup OnKey in VBA help.

[theta]

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