问题描述
是否有一种方法可以在引用列表的单元格上使用数据验证，但是组合框显示了多列范围.示例:单元格值必须是有效的代码(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
推荐答案
这篇关于我们如何在xl vba中使用数据验证添加多列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！