Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 04-13-2020, 01:52 AM
hassanmoukadem hassanmoukadem is offline Cell equal value new value of active cell which is a drop down Windows 10 Cell equal value new value of active cell which is a drop down Office 2019
Novice
Cell equal value new value of active cell which is a drop down
 
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
 

Tags
active cell, dropdown list



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
Cell equal value new value of active cell which is a drop down 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
Cell equal value new value of active cell which is a drop down 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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:17 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft