Text and value to combobox Excel VBA -

i have 2 tables in excel
first table: table students: id, last name, first name address , etc. table two: notes on students: each student can have records,i have 2 columns of table. student id , comments table want fill out form
form combo box students , text box entering notes, add button add records
wanted combo box appear name of student (last name+first name) , when click add, code put id student's of selected student

i thought combo box can set each row: text , value, text view , value not

as in asp.net

dropdownlist.datatextfield = name dropdownlist.datavaluefield = id 

now see text can set
wrong , can not known, , if not how can solve problem

you have declare 2 combo box
1 names , second rhe id
id's combo box there disables
order of 2 combobox listed order in appears in table

id of selected student:

cbxid.list(cbxnames.listindex)