从多页面获取activecontrol名称和值 [英] Getting the activecontrol name and value from a multipages form
问题描述
我已经在网上搜索了几个月的解决方案,没有任何成功。
我在 Excel 2010
a UserForm
中创建多页。我正在尝试编写一个函数,将获得 activecontrol
名称和值。
I've been searching the web for a solution for a couple of months without any success.
I created in Excel 2010
a UserForm
with multipages. I'm trying to write a function that will get the activecontrol
name and value.
到目前为止,我成功使用这个命令获取控件的名称
Me.MultiPage1.Pages(Me.MultiPage1.Value).ActiveControl.Name
但是我唯一能够做它是将它设置为变量作为字符串。
我仍然需要得到它的价值。
Until now, I succeeded in getting the name of the control using this command
Me.MultiPage1.Pages(Me.MultiPage1.Value).ActiveControl.Name
but the only thing I managed to do with it was to set it in to a variable as a string.
I still need to get it's value.
我真的很感激任何帮助。
blackmail
I really appreciate any help. blackmail
推荐答案
您可以使用以下代码访问MultiPage控件中最后一个主动控件的值: p>
You can access the value of the last active control in the MultiPage control with this code:
Me.MultiPage1(Me.MultiPage1.Value).ActiveControl.Value
但是,我不知道每种类型的控件都有一个 .Value
属性,因此请确保Multipage中的所有不同控件都有一个 - 或者包含一个正确的错误处理程序!
However, I'm not sure that every kind of control has a .Value
property, so make sure that all your different controls in the Multipage has one - or include a proper error handler!
这篇关于从多页面获取activecontrol名称和值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!