hassanmoukad
04-13-2020, 01:57 AM
I have a cell which i declared as active cell using developers tool in excel
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Range("C1").Value = ActiveCell.Value
End Sub
So whatever cell i click on, cell C1 will show that Value.
What i want to do it
Cell C1 is working correctly when i click acell, the C1 gets the value of that cell. But my issue is that, i have created drop down from Data Validation in specific cells. At first, when i click that cell , assume B1, C1 get the correct value of that cell, but when i select a new value from B1's drop down, C1 dose not change , it keeps that initial value. Is there a ways to make C1, change when i select a new value from B1's Drop Down?
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Range("C1").Value = ActiveCell.Value
End Sub
So whatever cell i click on, cell C1 will show that Value.
What i want to do it
Cell C1 is working correctly when i click acell, the C1 gets the value of that cell. But my issue is that, i have created drop down from Data Validation in specific cells. At first, when i click that cell , assume B1, C1 get the correct value of that cell, but when i select a new value from B1's drop down, C1 dose not change , it keeps that initial value. Is there a ways to make C1, change when i select a new value from B1's Drop Down?