| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dropdown menu
I want to creat a dropdown menu that will display in the cell on part of what
is shown on the dropdown menu. For example, if the dropdown menu item is "A101 - plan & prepare for", and want the cell to display "A101". Is that even possible? If so, how? Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dropdown menu
You can do this with programming. There's a sample file he
http://www.contextures.com/excelfiles.html Under data validation, look for 'DV0005 - Data Validation "Columns"' bonhill66 wrote: I want to creat a dropdown menu that will display in the cell on part of what is shown on the dropdown menu. For example, if the dropdown menu item is "A101 - plan & prepare for", and want the cell to display "A101". Is that even possible? If so, how? Thanks. -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dropdown menu
Thanks. But I guess I'm not smart enough to figure that out. Do you have an
easier explanation? "Debra Dalgleish" wrote: You can do this with programming. There's a sample file he http://www.contextures.com/excelfiles.html Under data validation, look for 'DV0005 - Data Validation "Columns"' bonhill66 wrote: I want to creat a dropdown menu that will display in the cell on part of what is shown on the dropdown menu. For example, if the dropdown menu item is "A101 - plan & prepare for", and want the cell to display "A101". Is that even possible? If so, how? Thanks. -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| filter dropdown menu so 2nd drop menu is customized | Excel Worksheet Functions | |||
| Create Dropdown menu without using the Validation on the Data Menu | Excel Worksheet Functions | |||
| Dropdown Menu | Excel Discussion (Misc queries) | |||
| dropdown menu or Jump menu | Excel Discussion (Misc queries) | |||
| Dropdown menu | Excel Discussion (Misc queries) | |||
Hybrid Mode
