Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help: Autopopulate/Edit disabled fields based on data in Sheet2
Hi All,
I have an excel userfom with a text box that accepts Student_ID. Once a student inputs ID in this textbox, other form fields like Name, Address, Ph_No will auto populate. The button to launch this form is on Sheet1 and the students data that auto populates is in sheet2. NOW, There are instances where new student data is not available in Sheet2 until I manually update Sheet2 with their info. So even if students are enrolled and they input their ID they dont see their Name, Address and Ph_No autopopulate in the fields. Is there a way where a student inputs the ID and if his or hers data is not present in Sheet2 the student can manually input the data which will then populate the Sheet2. Initially I have kept the Name, Address and Ph_No fields disabled as they are autopopulated, But for new students if it doesnt autopopulate, I want these fields to be enabled once a student inputs the ID for 3 times and the Name, Address, Ph_No fields dont autopopulate. SO for eg, IF a student inputs "123ef" in the ID fields and the Name, Address, Ph_No doesnt populate, the student will see a msgbox saying please input your ID again, This will happen for a total of 3 times, and the fourth time if the student inputs the Id and the fields dont autopopulate then the Name, Address and Hi All, I have an excel userfom with a text box that accepts Student_ID. Once a student inputs ID in this textbox, other form fields like Name, Address, Ph_No will auto populate. The button to launch this form is on Sheet1 and the students data that auto populates is in sheet2. NOW, There are instances where new student data is not available in Sheet2 until I manually update Sheet2 with their info. So even if students are enrolled and they input their ID they dont see their Name, Address and Ph_No autopopulate in the fields. Is there a way where a student inputs the ID and if his or hers data is not present in Sheet2 the student can manually input the data which will then populate the Sheet2. Initially I have kept the Name, Address and Ph_No fields disabled as they are autopopulated, But for new students if it doesnt autopopulate, I want these fields to be enabled once a student inputs the ID for 3 times and the Name, Address, Ph_No fields dont autopopulate. SO for eg, IF a student inputs "123ef" in the ID fields and the Name, Address, Ph_No doesnt populate, the student will see a msgbox saying please input your ID again, This will happen for a total of 3 times, and the fourth time if the student inputs the Id and the fields dont autopopulate then the Name, Address and Ph_No fields will be enabled and they will input their info manually which will then populate the Sheet2 with their info they just inputed. Hope I made it clear Thanks in Advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HELP: autopopulate certain form fields but make them editable late | Excel Programming | |||
autopopulate fields in userform based on selection in one field | Excel Programming | |||
fetch the data from sheet2 & place it in sheet1 based on the locat | Excel Programming | |||
Function on Sheet1 based on data on Sheet2 | Excel Worksheet Functions | |||
copy data from sheet1 based on criteria in sheet2 to sheet3 | Excel Programming |