Shortcut Key for Text Changing Color in MS- Excel
 

Please let me know how go assing the shortcut key for Fill Color and Font
Color in MS-Excel. Is MS-Excel having the feature of shortcut key for
formatting option.
Pls send ur reply to me on my e-mail id :-

Shortcut Key for Text Changing Color in MS- Excel
 

Hi Hema

Not build-in

Bold and Italic is possible but no colors
You can make your own macro if you want
Record a macro in your personal workbook

Selection.Interior.ColorIndex = 35


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Hema" wrote in message ...

Please let me know how go assing the shortcut key for Fill Color and Font
Color in MS-Excel. Is MS-Excel having the feature of shortcut key for
formatting option.
Pls send ur reply to me on my e-mail id :-

Shortcut Key for Text Changing Color in MS- Excel
 

Thanks for givien the ans of my question. I am sucessfully able to work/find
the macro for fill color, but I am anable to make a macro for Font Color(Text
Changing Color) in MS-Excel. Please porvided me the coding for making the
macro for Font color.

Please reply to me on my email id: .

"Hema" wrote:


Please let me know how go assing the shortcut key for Fill Color and Font
Color in MS-Excel. Is MS-Excel having the feature of shortcut key for
formatting option.
Pls send ur reply to me on my e-mail id :-

Shortcut Key for Text Changing Color in MS- Excel
 

Like this
Selection.Font.ColorIndex = 3


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Hema" wrote in message ...

Thanks for givien the ans of my question. I am sucessfully able to work/find
the macro for fill color, but I am anable to make a macro for Font Color(Text
Changing Color) in MS-Excel. Please porvided me the coding for making the
macro for Font color.

Please reply to me on my email id: .

"Hema" wrote:


Please let me know how go assing the shortcut key for Fill Color and Font
Color in MS-Excel. Is MS-Excel having the feature of shortcut key for
formatting option.
Pls send ur reply to me on my e-mail id :-

Shortcut Key for Text Changing Color in MS- Excel
 

Shortcut Key for Text Changing Color in MS- Excel
 

<vbg

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Peo Sjoblom" wrote in message ...

. Please porvided me the coding for making the
macro for Font color.

Please reply to me on my email id: .


Do you want us to take out your dog and wash your car as well? <bg

Do some research in Google


Peo