|
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. |
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 |
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 |
| All times are GMT +1. The time now is 08:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com