数据验证列表 [英] Data verification-lists

问题描述

通过选择数据验证并使用我的列表创建列表框后，我需要在列表中快速获取某个名称，使用第一个字母。例如：如果我有一个包含很多Product
名称的列表，我想写一封字母S来获取所有以S开头的产品（名称为"社交媒体在线课程"等） 。这个清单很长。我认为这早有
工作。



为什么这不再起作用了吗？



我可以做其他事吗？ 我可以使用任何分步说明对这些进行编程吗？

Once I've created a list box by selecting Data Verification and using my list, I need to quickly get a certain name in the list, by using the first letter. For example: If I had a list with a lot of Product names, I would like to write letter S to get all the products starting with S (for the name "Social media Online course" and so on). The list is long. I think that this have worked, earlier.

Why does this not work anymore?

Can I do anything else? Is there any step-by-step explanation I can use to programme these?

提前致谢，

Monica

推荐答案

您的意思是数据验证吗？不幸的是，它不支持自动完成，而且从不支持。有关替代方案，请参阅
http://www.contextures.com/xlDataVal10.html 。本文包含书面说明，教程视频和可下载的示例工作簿。

Do you mean Data Validation? Unfortunately, it doesn't support autocomplete, and never has. See http://www.contextures.com/xlDataVal10.html for an alternative. This article contains written instructions, a tutorial video and a downloadable sample workbook.

这篇关于数据验证列表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！