#1
|
|||
|
|||
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? |
#2
|
||||
|
||||
I don't use drop-downs much, so I may be wrong. But I think what you want for this is the Worksheet_Change event. When the user first clicks on a cell with a drop-down, the selection changed, so your first program works. But when the user changes the drop-down selection, the selection is still the same cell, but the value changed.
|
Tags |
active cell, dropdown list |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I test a cell for a specific word if the cell has a drop down list. | RoehamptonTech | Excel | 1 | 08-23-2017 05:05 AM |
Clear all cell colors within a range starting at cell A8 and change row of active cell to yellow | FUGMAN | Excel Programming | 7 | 02-05-2017 08:37 AM |
How to value cell G6 to be equal the value of A5, only when the value of cell A5 is more than 15? | tesoke | Excel | 3 | 01-14-2016 12:49 PM |
Automatically change the value of one cell so that two other cells become equal | matthew544 | Excel | 5 | 09-18-2011 08:56 AM |
Dividing merge cell into ten equal rectangles for inputing Digit? | aligahk06 | Excel | 0 | 05-12-2010 06:56 AM |