dynamic validation

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

steve - 28 Feb 2007 14:45 GMT

I want to validate all of the cells in Column G with a list of unique items
already in Column G. This can be triggered with the Sheet_Change event.

What is the best way to do this?

Reply to this Message

merjet - 28 Feb 2007 15:50 GMT

> I want to validate all of the cells in Column G with a
> list of unique items already in Column G.

I believe you need to describe your problem much more clearly. An
example will probably help.

Merjet

Reply to this Message

Tom Ogilvy - 28 Feb 2007 15:53 GMT

if application.Countif(columns(7),Target)>0 then
' its in the list

Signature

Regards,
Tom Ogilvy

> I want to validate all of the cells in Column G with a list of unique items
> already in Column G. This can be triggered with the Sheet_Change event.
>
> What is the best way to do this?

Reply to this Message

JE McGimpsey - 28 Feb 2007 16:00 GMT

Not sure what you're asking for - is there a specific range in column G
containing the list of unique items? Or are you trying to make sure all
the entries in column G are unique? Or something else?

> I want to validate all of the cells in Column G with a list of unique items
> already in Column G. This can be triggered with the Sheet_Change event.
>
> What is the best way to do this?

Reply to this Message