VBA Code Needed

nancybrown

Well-known Member
Joined
Apr 7, 2005
Messages
868
Could someone please help me with a VBA code. I'm new to VBA and have no clue what to write.

I have an employee table that has various fields including a field for employee competencies.

I have a second table for jobs with various fields including a field with required competencies.

I have a form that has a combo box to select a job of interest and will need a search to match the top 5 employee competencies to the selected job.

This needs to be dynamic as each job will have different competencies as well as each person having different qualifications. Is a loop required . . . no idea how to do this.

I was instructed to run a query and modify it in SQL view as a top 5, but I'm confused as to how to connect it to the selected job on my form.

Any help would be really appreciated.
 

Some videos you may like

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Watch MrExcel Video

Forum statistics

Threads
1,118,169
Messages
5,570,638
Members
412,334
Latest member
ExcelForLifeDontHate
Top