Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #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
  #2  
Old 04-13-2020, 07:54 PM
BobBridges's Avatar
BobBridges BobBridges is offline Cell equal value new value of active cell which is a drop down Windows 7 64bit Cell equal value new value of active cell which is a drop down Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

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

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
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 01:53 PM.


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