Pasty
You can use a Worksheet_Change macro. The code you write in that macro
would display a message box whenever the contents of that cell are changed
to either "partial" or "no". The message box would display whatever message
you want. What do you mean by "fill in some narrative.."? Provide more
detail about what you want. HTH Otto
"Pasty" wrote in message
...
Hi,

I have a list where they can select complete, partial or no. If they
select
partial or no I want them to fill in some narrative to explain why in the
next cell - is there anyway of getting a message or something to show this
when they select either of these options so it is blatantly obvious what
they
have to do and save me time chasing them.

Regards