| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
rETRIEVING DATA FROM EXCEL WORKSHEET TO CONTROLS IN USERFORM
hi! I have a userform with a texbox control where a user can input an ID no.
what i want is that when the length of textbox = 4 it will automatically search that number in a worksheet STUDENT PROFILE which has the ff. fields: ID no., lname, fname, mname, and addr. if that number is found its corresponding lname, fname, mname, and addr. will be displayed in the texboxes in that userform such as txtlname, txtfname, txtmname, and txtaddr. I hope you'll help me. Thanks in advance... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Retrieving data into worksheet from another worksheet in same work | Excel Discussion (Misc queries) | |||
| Excel worksheet retrieving data from Access | Links and Linking in Excel | |||
| Userform: listbox and controls' data entry validation | Excel Programming | |||
| Comparing & Retrieving Data From other worksheet | Excel Programming | |||
| Retrieving previously entered userform data from saved spreadsheet | Excel Programming | |||
Threaded Mode
