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.
Private Sub CommandButton1_Click() Private Sub OKButton_Click() Dim emptyRow As Long 'Make Sheet1 Active Sheets(1).Activate 'Determine emptyRow emptyRow = WorksheetFunction.CountA(Range("d:d")) + 3 'Export Data to worksheet Cells(emptyRow, 1).Value = Datebox.Value Cells(emptyRow, 3).Value = LFETextBox.Value Cells(emptyRow, 2).Value = BoxTopTextBox.Value Cells(emptyRow, 4).Value = Studentname.Value
Bookmarks