Hi guys, I need help for the following:
Currently, I have created a VBA form to search using either Student's name or Identification Number. What I would like to know is, How do I create a VBA code such that when i enter either the Student's name or Identification number, it will search through one excel sheet (that contains all the student's data) and return the result of this search within the user form. I do not want the Search function to bring me to the data in the other excel sheet.
I've attached how the userform should look like.
Also, all the data from which this search function would extract the search results are placed in a separate excel worksheet with columns starting with Names, Date of birth, Reading age, Spelling age, etc.. So essentially, once the search name coincides with the name in the data, VBA code is used to pull out all the relevant data of this person and display it on the Search Userform.
Thank you so much! Appreciate any form of help!!
Bookmarks