View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Piers 2k Piers 2k is offline
external usenet poster
 
Posts: 11
Default 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