excel - How can I give the "Font Color" button in the HOME ribbon a keyborad shortcut? -
what want keyboard shortcut, can use change color of selected characters in cell.
i have got code snippets recorded macro:
with activecell.characters(start:=3, length:=2).font .color = -16776961 end
now don't know how start
, length
activecell.characters
. , because want change of characters in cell, selected mouse, arbitrarily, required, need can't pass start
, length
parameter activecell.characters
.
i got stuck @ place, don't know how go on.
or, there way set keyboard shortcut font color
button?
or, there way achieve function want?
ps:
it's not difficult function want, think.
i want map ctrl-q
function change color (simply toggle black , red selected characters), default ctrl-5
can apply or remove strikethrough selected characters.
more precisely, wrote everyday's progress in given excel book. teacher check content , grammar me. has switch between mouse , keyboard, want map keyboard shortcut (of course i'm trying best make no mistakes in work..)
i don't know if it's necessary say, in case, content written in japanese (i mean don't know whether select method may different english.)
Comments
Post a Comment