Latest Lists

how do I put a dropdown list in an excel form?

I have one list of four items; then I have another list that needs to have lists to drop down within it. Are these macros or ActiveX or what? and how?

Public Comments

1. I think what you want can be found by going to Validation... on the Data menu and selecting List from the choices for Allow. If you want something more complicated than that, select View -> Toolbars -> Control Toolbox and look at ListBox or Combobox. If you want something more complicated than THAT (such as menus with submenus), I think you'll need to open your own form, using the version of Visual Basic that's embedded in Excel, which is called Visual Basic for Applications. You can open that up by selecting Tools -> Macro -> Visual Basic Editor. This will obviously involve some programming.
2. You can do this within the Excel software. First, create the possible values in the list in a column far from the data you are using. For example, use Z5-Z8 to enter the four items in, one per cell. Next, select the cell you want the drop down list to appear. Then click on the Data menu (on top) and click on Validation. In the Allow box, select List. In the source box, enter the range in which your items are listed in. For example, =$Z$5:$Z$8 When you click on the OK button, there should be a downdown arrow next to the cell you selected. Click on it to see the drop down list. Also note that the default behavior is to reject any values not on the list. An error message will come up saying the value entered isn't valid. The final thing you need to do is to hide the item list. Select cells Z5-Z8, click on Format menu (on top), click on Column, click on Hide. To unhide the selection list, you'll have to select the cells Y5-Y8 and Z5-Z8, click on Format menu, click on Column, click on Unhide.
3. U Can DO THis is 2 Ways If I have Understood u Properly U Want to display a List OF Data in Excel Form U Can Add iN a Sheet and List it with a Combobox or U Can Add to a Sheet and u can use Auto Filter Option and u can seek it