View Single Post
 
Old 04-13-2020, 01:52 AM
hassanmoukadem hassanmoukadem is offline Windows 10 Office 2019
Novice
 
Join Date: Apr 2020
Posts: 1
hassanmoukadem is on a distinguished road
Default Cell equal value new value of active cell which is a drop down

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?
Reply With Quote