Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Choose from a list
Good Morning,
Other than using the validation method and producing a dropdown box, is there any other methods available to show a list and allow a user to select one (or more) selections in a cell, while still displaying all of the choices on the list? Thanks Fred |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Choose from a list
Fred,
you can use an ActiveX combo-box or listbox on your sheet. If the values to choose are in, say, H1:H10: Right click on the menu area to display the Forms toolbar. Click combo or listbox and draw on Excel. Double-click the box to format. Use H1:H10 as Input Cells. Use another cell (e.g. F1) as Cell Link. The combo box will not put one of the values of H1:H10 in F1, but the ordinal number (1-10). Your output is computed with the formula: =INDEX(H1:H10,F1) HTH Kostis Vezerides On Jun 21, 6:08 pm, fgwiii wrote: Good Morning, Other than using the validation method and producing a dropdown box, is there any other methods available to show a list and allow a user to select one (or more) selections in a cell, while still displaying all of the choices on the list? Thanks Fred |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can excel choose a name from a list when I am typing in a cell | Excel Worksheet Functions | |||
How to choose from a list that includes blanks? | Excel Discussion (Misc queries) | |||
How can I choose a date from list with an agrument? | Excel Worksheet Functions | |||
How do I choose from the drop down list in excel | Excel Discussion (Misc queries) | |||
How do I insert A drop down dialog box as a 'list to choose from'? | Excel Worksheet Functions |