Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retaining Changing Font Color in Cell
I set out to do what I thought would be a simple macro and hit not one, but
two walls. The macro was to simply tack the date on to the current (text) contents of a cell and then leave that cell open (i.e. in edit mode) with the cursor ready for input after the date. The two walls that I hit were (1) leaving the cell open for input, and (2) retaining the changing font color formatting of the cell (often phrases or sentences in the cell are different colors from the rest). Are there reasonably easy ways around these two problems? I thought of using a simple form with just a text box instead of allowing the editing directly in the cell. That could solve the first problem but I still have the second. Thanks, Will |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Font color changing by itself | Excel Discussion (Misc queries) | |||
Changing Font color automatically when Cell Format is Percentage | Excel Worksheet Functions | |||
Changing Font color based on font type or size | Excel Discussion (Misc queries) | |||
changing font color of cell content | Excel Programming | |||
Changing Cell Font and Color Issue, | Excel Programming |