Excel functions

[question1]

Hello everyone,

Someone approached me the other day with an Excel spreadsheet that he wanted to replicate. In several of the columns (in the individual cells) there were list boxes present. Similar to the list boxes with Microsoft Access. He wants to be able to supply the user with a list of items of which to choose from so that their reports and data are consistent. I am not sure if they are actually called list boxes or forms or what.

Does anyone know how to create this function with Microsoft Excel. I have looked in the Excel help book, but again, I am not real sure as to what I am looking for.


Thank you in advance.

Troy

[mkcole]

If pull up the active X tool box, you will find everything from radial buttons, check boxes and drop menus. This is a great tool box for automating electronic forms or automate spreadsheets. When using the drop menu you will have to create your list in another section of the worksheet and refer to it when creating the menu. Hope this helps. http://www.PCGuide.com/ubb/smile.gif