Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
font color change
I'm trying to have excel change the font color in one cell based on the font
color change in another cell. I have a macro that will do this but I would like to have it occur right after the original font color is changed (possibly a sheet macro). My macro is: If Workbooks ("Manual Entry Numbers.xls").Sheets("Sheet1").Range("E17").Font.C olorIndex = 3 Then Range("G17").Font.ColorIndex =3 If Range("J18").Font.ColorIndex = 3 Then Range("G18").Font.ColorIndex =3 (this repeats several times) End If Any Ideas would be greatly appreciated Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
font color change
Unfortunately, no event fires on a change in font. You could use the
Worksheet_Calculate event and use an OnTime macro to perform calculations every few seconds, but if you run it very frequently (e.g., every second or two) it will tend to impact the performance of your sheet. In article , "Truseeker" wrote: I'm trying to have excel change the font color in one cell based on the font color change in another cell. I have a macro that will do this but I would like to have it occur right after the original font color is changed (possibly a sheet macro). My macro is: If Workbooks ("Manual Entry Numbers.xls").Sheets("Sheet1").Range("E17").Font.C olorIndex = 3 Then Range("G17").Font.ColorIndex =3 If Range("J18").Font.ColorIndex = 3 Then Range("G18").Font.ColorIndex =3 (this repeats several times) End If Any Ideas would be greatly appreciated Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
font color change
Hi
There are no VBA events that trigs at format changes like coloring, sorry. You'd have to assign extended custom macros to all toolbar buttons and menu items that are potentially used to do the coloring. No easy job. Best wishes Harald "Truseeker" skrev i melding ... I'm trying to have excel change the font color in one cell based on the font color change in another cell. I have a macro that will do this but I would like to have it occur right after the original font color is changed (possibly a sheet macro). My macro is: If Workbooks ("Manual Entry Numbers.xls").Sheets("Sheet1").Range("E17").Font.C olorIndex = 3 Then Range("G17").Font.ColorIndex =3 If Range("J18").Font.ColorIndex = 3 Then Range("G18").Font.ColorIndex =3 (this repeats several times) End If Any Ideas would be greatly appreciated Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Checkbox to change background color, font color and remove/ add bo | Excel Discussion (Misc queries) | |||
Cannot change font color or cell color | Excel Discussion (Misc queries) | |||
Change in font and color | New Users to Excel | |||
how can I conditionally change font color, or background color? | Excel Worksheet Functions | |||
How to change the default Border, Font Color, and Cell Color | Excel Discussion (Misc queries) |