Run Macro from specific cells
Hi folks,
Tried searching the web for this, but don't know what event I'm searching
for!
I have a number of cells in a certain column (F9, F15, F16, F23....)
Non-contiguous. After the number is entered in these cells, I want it to
trigger a macro to effect the adjacent cell (bg colour and font colour)
I can construct the macro and assign it to a button, but I am unsure of how
to tie it to a specific cell or cells.
Anyone?
TIA,
Piers
|