![](https://iknow-base.cdn.bcebos.com/lxb/notice.png)
excel vba 窗体中ComboBox1 选定的值赋给变量y,该怎样写代码呢?请高手帮忙!
1个回答
展开全部
'初始化模拟
Private Sub UserForm_Activate()
ComboBox1.AddItem 1
ComboBox1.AddItem 2
ComboBox1.AddItem 3
End Sub
'选中后赋值
Private Sub ComboBox1_Click()
y = ComboBox1.Text
End Sub
Private Sub UserForm_Activate()
ComboBox1.AddItem 1
ComboBox1.AddItem 2
ComboBox1.AddItem 3
End Sub
'选中后赋值
Private Sub ComboBox1_Click()
y = ComboBox1.Text
End Sub
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询