Macro based on changing cell

[elotromateo]

Is there a way to have a macro start whenever a certain cell changes value?



Also, for cells with a list, is there a way to reference the options in the cell via a macro?

 

[alan.m]

Hi,
you can make a macro run if a spefic cell is changed:
http://www.ozgrid.com/VBA/run-macros-change.htm

your second question isn't quite clear.
the following will show you the contents of a data vaildation list:
sub whatever()
Dim strChoices As String
Dim choice

Range("E4").Select
strChoices = Selection.Validation.Formula1
MsgBox (strChoices)
end sub

 

[elotromateo]

The first part helped a lot, but still is not quite perfect and I don't think it can really be done. The cell being changed is a list and I would like the macro to run once the cell has been changed from one value to another. As it currently is, once the value is changed, you need to go to another cell, and then return to the target cell, which I would like to avoid.



Sorry for not being clear about the second part. Is there a way to pull specific values from a list in a cell with a macro. So if the options are (A,B,C,D), then the macro will pull out option A (if so desired).

 

[elotromateo]

Nevermind, I've decided to use a Combo Box and tie the macro to it so that will work there.

Also I figured out how to make an array, so the second problem has been solved as well.

Thanks for the help.