Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Font color buttons?
Excel2000
The font color toolbar button works to change (A) an entire cell (or selection of cells), or (B) selected text within a cell. I'd like to create a couple of custom buttons, one for red text, one for black etc., etc. The code for (A) is relatively straightforward. The code for (B) is a mess, at least if you try to record a macro. Anyway, as a first step, how would you distinguish in VBA between "cell or range is selected" and "cell contents are selected"? Then, how do you generalize (B) such that the code changes the color of whatever text happens to be selected? Thanks very much. Jay |
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) | |||
Conditional Format for font color using font color | Excel Worksheet Functions | |||
Changing Font color based on font type or size | Excel Discussion (Misc queries) | |||
How to change the default Border, Font Color, and Cell Color | Excel Discussion (Misc queries) | |||
My fill color and font color do not work in Excel Std Edition 2003 | Excel Discussion (Misc queries) |