data validation

[cybergremlin]

Hi

Is it possible to link multiple data validation boxes?
What i mean is if i have a validation box in cell B1 and another in cell C1 when i update 1 the other also updates and visa versa?

thanks

 

[Puertorekinsam]

If you want the options for the validation to update, you just need to use an "=IF" formula on the cells containing the list of options


If you want the actual value to update... you will need to use VBA and a Value Change handler

Private Sub Worksheet_Change(ByVal Target As Range)


If Target.Row = 1 And Target.Column = 1 Then
    'Your Code
    'cells(1,2)="New Value"
    
End If
End Sub

 

[My Aswer Is This]

Do you mean Data Validation List?

I'm not sure what a:

multiple data validation boxes

Are.
​

 

[cybergremlin]

Do you mean Data Validation List?

I'm not sure what a:

multiple data validation boxes

Are.
​

Yes sorry data validation lists, more then 1 data validation list that update when you click on one of the lists the other lists also update and vice versa

 

[My Aswer Is This]

So tell me more:

You have a data validation list in lets say A1 which when clicked on gives you choices to choose from

And this list of values comes from where?

Did you enter them in the data validation dialog box individually or does the list of values come from a range on your sheet.

And you have two Ranges with data validation list

Like A1 and C1

And now you want both list of values to change when. I'm now not sure what your wanting

You want the list of available choices to change?

 

[cybergremlin]

sorry, its probably how I'm explaining it,
I have a list in say A1:A5. dog, cat, wolf, sheep, horse.

In cell B1 i have the validation list based on A1:A5
In cell C1 i have another validation list based on the same data in A1:A5.
What i want (if possible) is when i choose either dog, cat etc in cell B1, C1 also shows the same animal but if i choose a animal in cell C1, B1 updates.

hope this makes sense

 

[My Aswer Is This]

Try this:
This is an auto sheet event script
Your Workbook must be Macro enabled
To install this code:
Right-click on the sheet tab
Select View Code from the pop-up context menu
Paste the code in the VBA edit window

Private Sub Worksheet_Change(ByVal Target As Range)
'Modified  12/12/2018  1:57:11 PM  EST
Application.EnableEvents = False
If Target.Column = 2 And Target.Row = 1 Then Range("C1").Value = Target.Value
If Target.Column = 3 And Target.Row = 1 Then Range("B1").Value = Target.Value
Application.EnableEvents = True
End Sub

 

[cybergremlin]

Try this:
This is an auto sheet event script
Your Workbook must be Macro enabled
To install this code:
Right-click on the sheet tab
Select View Code from the pop-up context menu
Paste the code in the VBA edit window

Private Sub Worksheet_Change(ByVal Target As Range)
'Modified  12/12/2018  1:57:11 PM  EST
Application.EnableEvents = False
If Target.Column = 2 And Target.Row = 1 Then Range("C1").Value = Target.Value
If Target.Column = 3 And Target.Row = 1 Then Range("B1").Value = Target.Value
Application.EnableEvents = True
End Sub

This is exactly what i needed, thank you

 

[My Aswer Is This]

Glad I was able to help you.
Come back here to Mr. Excel next time you need additional assistance.

This is exactly what i needed, thank you

 

[cybergremlin]

Glad I was able to help you.
Come back here to Mr. Excel next time you need additional assistance.

If im correct the the VBA code refers 1 cell the ther other cell so how would i add another validation list to the code say in cell D1?