create a data entry, data view form with drop down lists

Good evening all.

Trawling of the forum has not thrown up quite the solution a biff like myself requires so heres a direct appeal.

I want to use a form pretty much similar to the one built into Excel to allow my staff to view equipment records and add new ones as necessary, however I can't allow them to type in whatever they want so I want to force them to select from a list instead. The lists already exist as named ranges within my workbook.

Do any of you have some examples I can blag and pretend are my own or can you point me at a tutorial to create something like the built in excel form but with lists instead of free text.

Thanks for any guidance

Simpo