H
HONYAKUKA
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
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