Worksheet Change

[thisisgerald]

Hi Guys,

I have a worksheet with a drop down data validation. listed (A,B,C)

Under my code in

Please Login or Register  to view this content.

Once I select any on the validation, I will put text in "A1" and it is ok.
My problem is when I delete the text selected on the data validation,
i want the text in "A1" to be also deleted.

Any idea guys?

Thanks in advance.
thisisgerald

[JosephP]

which cell has the dropdown?

[thisisgerald]

which cell has the dropdown?

I have the drop down at Range("G2")

Basically I have a lot of Drop down list starting at Range("G2") plus 5 rows on the next
data validation with the same list depending on a condition. (data validation was generated by vba) So I also need to get which row I changed the value on column G.

[JosephP]

if you want to monitor G2:G7 for example

Please Login or Register  to view this content.

[thisisgerald]

I'm currently working with your code.
I have a question. What if in Range("A1"), it is merged until column C?

it would be the same as like this?

Please Login or Register  to view this content.

[JosephP]

no you'd need

Please Login or Register  to view this content.

even better-don't use merged cells ;-)

[thisisgerald]

It's now okay.

I'll have to use your code and expand it as it fits my needs.

Thanks for your logic JosephP!

Rep. added!