VBA; Replace cell content with B when A is selected

[niicommey]

Hello, I am new using VBA. I have data in 2 columns A with corresponding data in B. I have used the data in column A as a drop down menu. I want an excel VBA code that will retrieve data from column B and use that to replace the data selected from A. A sample data is below
A
Blue
Green
Purple
Yellow
Red

B
Apple
Lemon
Banana
Orange
Melon

The vba should should replace Blue with Apple when I select Apple from the drop down list and Yellow with Orange

 

[My Aswer Is This]

So are you saying the values in column A are from a DataValidation.list
And if you select Apple from the validation list you want this value changed to the data in column B same row?
That would not be possible using a sheet change again event script because the value now put in column A is not a value in the datavalidation list

 

[niicommey]

So are you saying the values in column A are from a DataValidation.list
And if you select Apple from the validation list you want this value changed to the data in column B same row?
That would not be possible using a sheet change again event script because the value now put in column A is not a value in the datavalidation list

Yes, the data in column A is from a Data Validation List. Is there no way it can be done? Because I don't need the new value which is from column B to be in the data validation list.

 

[My Aswer Is This]

Yes, the data in column A is from a Data Validation List. Is there no way it can be done? Because I don't need the new value which is from column B to be in the data validation list.

I think you said you had a Datavalidation list in column A is that correct?
And if you select "Cat" from the Datavalidation list you want "Cat" replaced with "Dog" which is in column B of same row.
Is this not correct?

 

[My Aswer Is This]

You said:
Because I don't need the new value which is from column B to be in the data validation list.
So what do you want to happen?

 

[My Aswer Is This]

So what do we want to do?

 

[My Aswer Is This]

If we enter the value in column B into same cell in column A it really does not change the Datavalidation list which is somewhere else. But a message box will pop up saying that is not a valid entry.

 

[niicommey]

If we enter the value in column B into same cell in column A it really does not change the Datavalidation list which is somewhere else. But a message box will pop up saying that is not a valid entry.

Ok. I will then have to find another way.