我们如何在xl vba中使用数据验证添加多列 [英] how can we add multiple columns with data validation in xl vba

问题描述

是否有一种方法可以在引用列表的单元格上使用数据验证，但是组合框显示了多列范围.示例:单元格值必须是有效的代码(A65110，...).当查看下拉框时，用户会看到projectID和解密的列表(A65110 Jones Project，...).当用户从列表中选择时，仅用代码填充单元格. Access具有将字段(单元格)链接到其他字段以协助数据输入的功能. Excel在数据验证方面是否具有类似的功能?
请帮助我

Is there a way to use data validation on a cell that refers to a list but the combo box shows a multi column range. Example: Cell value needs to be a valid code(A65110, ...). When the drop down box is viewed the user sees a list of projectID''s and decription(A65110 Jones Project, ...). When the user selects from the list, the cell is populated with just the code. Access has a feature linking a field (cell) to other fields to assist data input. Does Excel have a similar feature with data validation?
plese help me

推荐答案

据我所知，您在Access下拉列表中描述的功能在Excel中不存在.但是，如果您可以将数据定义为两列(一列用于ID，另一列用于对应的描述)，则可以将描述列用于下拉列表，然后使用VLookUp拾取ID.可以吗?

As far as I am aware, the functionality as you have described in an Access drop down does not exist in Excel. However, if you can define the data as two columns (one for ID and the other for the corresponding description), you can use the description column for the drop down list, and use VLookUp to pick up the ID. Will that do?

这篇关于我们如何在xl vba中使用数据验证添加多列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！