Font ColorIndex, Ws Change Event

[Guest]

Hi -
I'm building an App where the User's Wbk is referenced to an Addin.
A 'parm' sheet in the user's wbk has a sheet change event macro.

call MgrEdit(target.address) ' the edit macro is in the addin

Changing ONLY the font color of a cell does not seem to fire the change
event.
I'm looking for a way to crank up the edit immediately after the user clicks
the desired color in the standard palette.

It's a little screwy, but I need to edit the
cells(row,col).font.colorindex after I convert the $a$28 to row and col
values(which is working nicely).

I know that I can:
1. Ask the user to change the text value in the 'color' cell after
changing the color, but that also has a meaning in the app, and the user
would then have to change the text back to the 'really' desired text value.
Simple for me, but "klugy" to the user.

2. Build a macro that controls the font color selection and fire the edit
after the selection. 2a. Build another Menu entry the user would select
after changing only the font color of the cell. Both seem like overkill.

3. Edit the value when the 'next' macro is run by the user. Inconsistant
with the way the other cells are treated re: 'parm' sheet 'real' value
changes when the edit does fire on a change.

Is there a more straight forward way?

Thanks,
Neal Z.

 

[Guest]

Hi Neal, try this scenario. Just before the user does anything:

x = ActiveCell.Font.ColorIndex
'Do your thing with the changes
If ActiveCell.Font.ColorIndex <> x Then
'Do something, color has changed
Else
'Do nothing, color is the same
End If

 

[Guest]

Hey JL-
Thanks. I think your suggestion is a variation on on my item 3, but it's
given me this idea.
1. Storing the color integers is easy, either hidden in the worksheet or
perhaps in a public array.
2. Unless this font color change is the LAST THING the user does on the
sheet(and I can trap it then on the de-activate event) he's gotta move the
cursor somewhere else on the sheet and I should be able to trap it on the
selection_change event.
I think this will work, 'cuz in the context of the application, there are
other things for the user to do after he/she does the color change.

Ya think ?
thanks