| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Shortcut Key for Text Changing Color in MS- Excel
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 :- |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 :- |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 :- |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Shortcut Key for 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: . Do you want us to take out your dog and wash your car as well? <bg Do some research in Google Peo |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| unhide menu bar in excel - just disappeared | Setting up and Configuration of Excel | |||
| Is there a shortcut key to move between sheets in Excel? | Excel Discussion (Misc queries) | |||
| Changing a word document into an excel spreadsheet | Excel Discussion (Misc queries) | |||
| excel 2003 changing saved print settings | Excel Discussion (Misc queries) | |||
| Is there a keyboard shortcut for centering data in Excel? | Excel Discussion (Misc queries) | |||
Hybrid Mode
