Hi I have two list boxes that I'd like to be able to select the value in one list and it automatically selects the value in the second list. but I'd also like to be able to change the value from the default selection in list 2 - so initially it might have one value but the user opts for a different value.

Column A contains a cell (possibly with data validation list or combo box - which ever will work with this!) that will have Yes / No / Maybe
Column B contains a drop down list with Yes / No / Maybe values

If Yes is selected in column A then select yes from the list in column B
If Maybe then select maybe from the list in column B

Values in Column B need to be able to be changed by the user (e.g. although Yes = Yes there may be circumstances where it actually needs to be Maybe etc)

This is a simplified version of what I am trying to do and there will be a number of cells this needs to be applied to with different outcomes, I believe this needs to be done in VBA as my current approach of using a list box / formula means that the formula is over written when the list box is used, so if value in Column A is then changed the changes don't flow through the worksheet.

Example attached!Book1.xlsx