Excel 2007 : Combobox works with On sheet data validation list but not Off Sheet list

Attached is an example that I pulled from Contextures website (Grovier). There a re 3 sheets. The first sheet if the original file and all works as it should, In which the combobox attaches itself to the active cell containing data validation using one click. The lists for the data validation are contained on the same sheet.

Sheet Two: is the same thing modified such that the data validation lists (moved to sheet List) are using the named Ranges of the lists offsheet. Most of the functionality of the combobox no longer works. Namely the font change , number of items the list dispplays on click, autocomplete dont work any more.

any thoughts?

JB,

Thanks for pointing out the need to declare to the wcLists variable, I missed that.

The Macro you removed is an important component that would facilitate natural keyboard data entry without having to use the mouse to "Click" on the next cell. In that, it functions in the Original Sheet to move the combo-box upon the use of a Tab or Enter to the next cell.

Can you see what is preventing that Macro from performing as it should once the data validation lists have been moved to another sheet. (At least that is what appears to have been the culprit in breaking the Macro)

Hmmmm. Would you kindly send me your file. I've just retried it and neither Alt, Tab or Enter moves me into the next cell. Not sure what the difference is.

Thanks in advance for your help.

Thanks again JB. I see that with the macro at the bottom it works for that sheet. Excitedly, I adapted it to my own application and it fails. No idea why. It's all seems pretty straightforward.