Thread: autocomplete combobox not repeating on other sheets

Have been trying to replicate an autocomplete combobox in a daybook file. Using code obtained from a JBoucaire post on this forum and other sources I have a working instance on the worksheet "LISTS" (yellow/green highlighted sectionxs).

When I try to replicate this on the validated entry sections (these are all dynamic named ranges) on the other daysheets, such as "DAYSHEET1" it refuses to work.

I have moved the code to the relevant worksheets but then it gives me combobox name error

Will I have to create a differently named combobox for each sheet refering to ranges specified on the worksheet "LISTS" or is there a simpler method

Any help appreciated

sample file attached

Have now managed to get autocomplete combobox to work on DAYSHEET1. I still cannot replicate this for sheets 2 and 3.

I have tried different code and combobox name for each sheet but cannot find a way around it.

Any ideas appreciated

file with working sheet1 attached