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

Popular posts from this blog

sequelize.js - Sequelize group by with association includes id -

android - Robolectric "INTERNET permission is required" -

java - Android raising EPERM (Operation not permitted) when attempting to send UDP packet after network connection -