[VBA] Set a shortcut key for "Copy Format"

[smallxyz]

Hi,

Is there a way to set a shortcut key for "Copy Format" ?
Or use VBA to imitate the usual mouse-click / mouse-double-click function of "Copy Format"


Thanks a lot!

 

[vletm]

smallxyz
You asked about ... copy format
... hmm? ... You can use Ctrl+C.
... it 'includes' copying format.

 

[Fluff13]

Cross posted https://www.mrexcel.com/forum/excel-questions/1112968-set-shortcut-key-copy-format.html

 

[vletm]

smallxyz
You should reread https://chandoo.org/forum/threads/site-rules-new-users-please-read.294/