Keith
From what you say, I don't think you need any code. What you say you
want is one list dependent on the selection from another list. Look here
for details about how to do that. HTH Otto
http://www.contextures.on.ca/xlDataVal02.html

"Keith" wrote in message
...
I have a sheet that logs what type of call a rep has made. The sheet can
have 10 - 15 entries on it. So whit will happen is:

Cell F5 has a validation list assigned to it with three values. Acute,
Primary and Other. Depending on which option is selected I want the cell
G5
to have its validation list changed to represent the options for the value
in
F5. All the lists have been defined on another sheet as named ranges.

As above this will be the same for the other rows. So the value set in F6
will effect the validation list for G6.

I hope this makes sence.


"Otto Moehrbach" wrote:

You would use a Worksheet_Change event macro. Within the macro, you
would
write code to continue execution only when that specific cell's value
changes. Subsequent code would do what you want for the specific value
entered. Post back if you need further help with this. Include more
detail
about what you have and what you want to happen. HTH Otto
"Keith" wrote in message
...
I have three pieces of code. Depending on the value of a specific cell I
want
one of these bits of code to run. The code doesn't assign a value to a
cell
but sets another cells validation list.

How can I get this code to run automatically? If it was Access I would
assign the code to the on change event of the field, but I don't know
if
this
is possible in Excel.