ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I add a drop down box within a drop down box? (https://www.excelbanter.com/excel-discussion-misc-queries/191023-how-do-i-add-drop-down-box-within-drop-down-box.html)

auroraruth

How do I add a drop down box within a drop down box?
 
I tried to use indents to show sub-choices, but the indents don't show up in
the validation box. Using Excel 2003.

FSt1

How do I add a drop down box within a drop down box?
 
hi
i am not aware that you can do that. but as an alternative you might try
dependent dropdowns sometimes called cascading combos.
you didn't say if you were using data validation, sheet combos or form
combos(they are all drop downs) so i'll guess data validations. see this site
for details.
http://www.contextures.com/xlDataVal02.html

regards
FSt1

"auroraruth" wrote:

I tried to use indents to show sub-choices, but the indents don't show up in
the validation box. Using Excel 2003.



All times are GMT +1. The time now is 03:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com