Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
autopopulate fields in userform based on selection in one field
Hi All,
I have an excel userform that has a dropdown field called "Leader". What I want is: Once we select a value from leader dropdown. I want three other fields to auto populate based on what we select in "Leader" dropdown. For eg: I want Student1, Student2 and Location to be auto populated once we select a value from "Leader" dorpdown. NOW, one thing with this is, All this data is stored in an excel workbook on shared drive. And the Students, Locations, and leaders keep switch regularly. All this changes are updated in the workbook. Is there a way to design all this fields such that It take the data from that updated excel workbook? For eg: Today if Leader: "John" has Student1: "Jack" and Student2: "Jill" and Location: "1" I want Jack, Jill and 1 to autopopulate in my user from once I select John from Leader dropdown. Tomorrow If Leader: "John" has Student1: "Bill" and Student2: "Josh" and Location: "1" I want Bill, Josh and 1 to autopopulate in my user from once I select John from Leader dropdown. Hope I made it clear Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Populate fields based upon dropdown selection | Excel Discussion (Misc queries) | |||
auto populate a field based on other fields | Excel Programming | |||
Pivot Table Field based on two data area fields | Excel Worksheet Functions | |||
Userform enter a field checking other two fields - Thank you | Excel Programming | |||
Copy multiple fields based on the info in 1 field | Excel Discussion (Misc queries) |