Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enter data into a cell and dynamically update another cell
What version of Excel are you using?
-- Regards, Tom Ogilvy Darcy wrote in message ... I've got data validation turned on for cell that has a 'list' attached to it. Once I select something from the list in the cell, I want to automatically update the cell next to it with a description. The one cell that has the list in it is an account number, and I want the account description to show up automatically right after you hit enter. I don't want to do it with a formula though. I've tried using the Worksheet_selectionchange and the Worksheet_change but haven't had any luck. Please help me out. Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto enter date when data in enter in another cell | Excel Worksheet Functions | |||
is there a way to enter data interactively and dynamically? | Excel Discussion (Misc queries) | |||
enter data in cell but cannot save until click off cell in excel | Excel Discussion (Misc queries) | |||
How to dynamically select a validation list from data in a cell? | Excel Discussion (Misc queries) | |||
Enter data into a cell and dynamically update another cell | Excel Programming |