Mike in Phoenix
New Member
- Joined
- Mar 5, 2004
- Messages
- 2
I need to perform a two column lookup to check to see if a person's first and last name are already in the worksheet. I use forms to input student data and also to associate students with events and programs. Only the students first and last name are captured in the association process.I would like to prevent students from being associated with events or programs until the full student bio has been captured.
I have a sheet just for lookups and each time a student bio is completed the fist name goes in column J and the last name goes in column K on the same row, of course. Up to four students' names will need to be checked with one click event. The variables being used will be txtFirst1 and txtLast1 through 4.
So I need to check to see if the 4 pairs of txtFirst and txtLast match any row pair in columns J and K.
This will need to be done in VBA and not a spreadsheet formula.
Thanks in advance for your efforts!
I have a sheet just for lookups and each time a student bio is completed the fist name goes in column J and the last name goes in column K on the same row, of course. Up to four students' names will need to be checked with one click event. The variables being used will be txtFirst1 and txtLast1 through 4.
So I need to check to see if the 4 pairs of txtFirst and txtLast match any row pair in columns J and K.
This will need to be done in VBA and not a spreadsheet formula.
Thanks in advance for your efforts!