Running Macro based on a cell being equal to specific value

[mbrady1973]

Hi,

I have a combo box that is linked to cell N1.

If cell N1 = "Option Not Listed", then I want a macro to run automatically.

Any suggestions are greatly appreciated.

[shg]

The cell link for a combo box from the Forms toolbar receives the list index (a number) for the box, so I'm not sure what you mean.

If you used a combo box from the Control Toolbox, you could test the value in its change event.

[mbrady1973]

it is a combo box. the results show up in the linked cell.

For ex...

If I pick "Monday" from my combobox, in cell N1 (my linked cell),it will display "monday".

What I am looking to do is run a macro if cell N1=a specific value