VBS matching names and auto populating cell with associated year

**nancytaylor** · 10-26-2013, 09:32 PM

Form Test.xlsmI am working from two worksheet.
Collection Worksheet is an input worksheet where I type in the gathered information. Column D contains a drop down list of names.
Information Worksheet contains list of student names (column e) and graduating year "Column D". I am able to accomplish this by using this formula =INDEX(Individualnames!$D$3:$D$24991,MATCH(D43,Individualnames!$E$3:$E$24991,0)) and manually filling the cells.

I am new to programming a form. I have created a form to type in the collected information. I would like to populate a cell with the graduation year with the associated name.

I have created a form with the program below. I am not sure how to program the above formula into the program. Can someone please help me.

Thanks.

Please Login or Register  to view this content.

**AlphaFrog** · 10-27-2013, 03:24 AM

I don't really follow what you want done?

If you're trying to determine the row number of the selected name in the Studentname combobox, you could use its selected item index number. Each item in the combobox list has an index number starting at zero. So if the second name is selected (index 1), and the combobox list is from cells starting at row 3, then the selected name's row is 4 (1 + 3)

StudentNameRow = Studentname.ListIndex + 3

**nancytaylor** · 10-27-2013, 11:21 AM

I probably didn't explain it very well.

I choose a student name from the drop down list on the form.
The names comes worm worksheet 2. I want the information from the cell next to the name to populate a cell in worksheet (1)
when I click the OK button.

Thanks for any help.

**alansidman** · 10-27-2013, 11:25 AM

Welcome to the forum
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(I have added them for you this time. Please read our rules and adhere to them in the future.)