动态创建下拉验证列表 [英] Drop-down validation list created dynamically
问题描述
在A1范围内,我有一个下拉验证列表.根据用户从该列表中的选择,我想在C1范围内动态创建一个新的下拉验证列表. 例如,在A1中,列表包含:
In range A1 I have a drop-down validation list. Based on the user's selection from that list I would like to dynamically create a new drop-down validation list in range C1. For instance, in A1 the list contains:
A
B
C
因此,如果用户从列表中选择A,则C1中的新列表将包含:
So if the user selects A from the list, the new list in C1 contains:
1)令人讨厌的橘子
2)愤怒的小鸟
3)任意样本
如果用户选择B,则新列表包含:
If the user selects B, the new list contains:
1)膨胀代码
2)最好不要说
3)尝试失败
等
使用VBA轻松完成.但是在GAS中...............................
Easy enough to do using VBA. But in GAS.... I have absolutely no idea of how to even start :/
推荐答案
用于数据验证的Apps脚本API刚刚发布: http://googleappsdeveloper.blogspot.com/2013/08 /answering-another-top-request-data.html
The Apps Script API for data validation was just released: http://googleappsdeveloper.blogspot.com/2013/08/answering-another-top-request-data.html
这篇关于动态创建下拉验证列表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!