How to make Data Validation Lists Autocomplete

[cricket1001]

I made 2 Data Validation Drop Down Lists that work fine. But I would like to have them autocomplete when I type 1, 2 or 3 letters.

• I have a "Checklist" worksheet with Officer Names listed in E5:E34.
  • I have 5 columns with data validation drop down lists
    • F5:F34 is Meats1 Drop Down List
    • G5:G34 is Meats 2 Drop Down List
    • H5:G34 is Sides 1 Drop Down List
    • I5:I34 is Sides 2 Drop Down List
• I have a "Data Sheet" worksheet with 2 data tables for the drop down lists
  • tblMeats
  • tblSides

I have done research and found info to:

1. Draw ComboBox
   1. Problem is, where do I add the ComboBox?
      1. Checklist worksheet
      2. Data Sheet worksheet
   2. I've tried both and can't get it to work.
2. Change Properties in ComboBox
   1. Name to tempCombo
   2. LinkedCell = the cell where table header, tblMeats, B4
   3. ListFillRange = B5:B10
   4. MatchEntry = 1 - fmMatchEntryComplete
   5. Problem is if I put the ComboBox in the Checklist worksheet, where I think it is supposed to go, I can't put in anything for the LinkedCell nor ListFillRange because they are in the Data Sheet worksheet.
3. Copy VBA & paste in ??
   1. Which worksheet should I put the VBA into?
   2. I tried both and neither worked
4. I don't understand how to make my tblMeats and tblSides drop down lists autocomplete especially by having 2 separate worksheets.

 

[herofox]

where's Excel File ؟!!!Not to waste teachers' time and guesswork can't be done
Or who will prepare and make a ready-made file for you?!!!!