cricket1001
Member
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 done research and found info to:
- 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 5 columns with data validation drop down lists
- 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:
- Draw ComboBox
- Problem is, where do I add the ComboBox?
- Checklist worksheet
- Data Sheet worksheet
- I've tried both and can't get it to work.
- Problem is, where do I add the ComboBox?
- Change Properties in ComboBox
- Name to tempCombo
- LinkedCell = the cell where table header, tblMeats, B4
- ListFillRange = B5:B10
- MatchEntry = 1 - fmMatchEntryComplete
- 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.
- Copy VBA & paste in ??
- Which worksheet should I put the VBA into?
- I tried both and neither worked
- I don't understand how to make my tblMeats and tblSides drop down lists autocomplete especially by having 2 separate worksheets.