背景
我有一个带有多页的userform、一个文本框和一个命令按钮。每个多页也有许多文本框。我希望能够从第一页的最后一个文本框移到第二页的第一个文本框,等等,从最后一页的最后一个文本框移动到多页下面的文本框。
我以为我已经为此创建了一个解决方案(如下所示);但是,我的解决方案不允许用户(鼠标)单击非下一个选项卡或多页对象下面的文本框来中断选项卡顺序。相反,他们必须在多页对象的整个过程中选择选项卡,这可能涉及到大量不必要的选项卡。
尝试
在每次运行tabDirect的末尾,我都试图将全局var NonTab重置为NonTab。结果是,第一次单击(指向不同的页面或多页对象外部)被视为选项卡,而第二次单击实际上被视为mouseclick。
我还尝试在userform中的mouseclick事件中将tabDirect更改为NonTab。但是,当前页外控件的mouseclick事件从未发生。
经过研究后,似乎当多页下面的文本框上发生了mouseclick时,事件如下:
在MouseDown事件之后还有其他事件吗?或者另一种方法来判断鼠标是否被点击,或者在退出事件中按下了哪些键?
Notes
我知道另一个通过插入命令按钮来完成页面跳转的建议,这个命令按钮在选项卡上时,可以说是“翻转页面”到多页对象中的下一页。我希望找到一条看上去更干净的路线;因此,multipage_exit子程序中的代码就出现了。
我亦十分明白,我的问题的答案最终可能是“不可能”。然而,人们有时会想出令人惊奇的方法来解决困难的问题,我想我希望这将是一个这样的时代。
尽管如此,我也愿意听取其他意见/建议,以便在多页对象的页面中添加选项卡。
惯性码
全局变量
Public tabDirect As tabbing
Public Enum tabbing
[_First] = 1
NonTab = 1
Forwards
Backwards
[_Last] = 3
End EnumUserform子
Private Sub Multipage_Exit(ByVal Cancel As MSForms.ReturnBoolean)
Dim counter As Integer
Dim cnt As Integer
If tabDirect <> NonTab Then 'If not tabbing, skip to end of sub
' determines value of next page
If tabDirect = Backwards Then
counter = Multipage.Value - 1
ElseIf tabDirect = Forwards Then
counter = Multipage.Value + 1
End If
'If tabbing backwards while on the first page,
'the counter would have a value of -1 here
If counter < 0 Then '
counter = Multipage.Pages.Count - 1
End If
'Only way for counter to equal Multipage.Pages.Count,
'is if tabbing forward off of last page.
'Desired result is to leave the multipage
If counter <> Multipage.Pages.Count Then
'Tabbing forwards: want first textbox, tabbing backwards: want last
If tabDirect = Backwards Then
cnt = Multipage.Pages(counter).Controls.Count - 2 ' skip over label
Else
cnt = 0
End If
Multipage.Value = counter
With Multipage.Pages(counter).Controls(cnt)
.SetFocus
.SelStart = 0
.SelLength = Len(.Value)
End With
'Fixing scollbar
If tabDirect = Backwards Then
Multipage.Pages(counter).ScrollTop = Multipage.Pages(counter).ScrollHeight
Else
Multipage.Pages(counter).ScrollTop = 0
End If
'Don't want to cancel when leaving first page backwards
If tabDirect <> Backwards Or counter <> Multipage.Pages.Count - 1 Then
Cancel = True
End If
Else
Multipage.Value = 0
Multipage.Pages(0).ScrollTop = 0
End If
End If
End Sub窗体上每个文本框的textbox类中的代码
Private Sub Textbox_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
'KeyCode 9 = tab
If KeyCode = 9 And Shift = 1 Then
tabDirect = Backwards
ElseIf KeyCode = 9 Then
tabDirect = Forwards
Else
tabDirect = NonTab
End If
End Sub每个控件在userform上的MouseDown事件中的代码
Private Sub Control_MouseDown(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
tabDirect = NonTab
End Sub发布于 2018-02-12 19:21:59
虽然我无法找到区分选项卡和鼠标的方法,但我确实找到了另一种方法来确定多页是否退出,而不是跳转到下一个文本框。
我的假设是,如果一个多页退出事件是由选项卡触发的,那么最近输入的textbox将是页面上的第一个文本框(向后选项卡)或最后一个文本框(选项卡向前)。因此,如果当前textbox的名称与我正在观察的名称(第一个或最后一个)相匹配,则多页应该继续到下一个页面(根据我以前的逻辑)。因此,我作了如下修改。
更改代码
添加全局变量
Public enteredBox As String添加到每个KeyDown和MouseDown事件中的代码
enteredBox = Control.Name使用新代码编辑退出事件,如下所示
-----------
| New Code
-----------Private Sub Multipage_Exit(ByVal Cancel As MSForms.ReturnBoolean)
Dim counter As Integer
Dim cnt As Integer
-----------------------------------
| Dim idWanted As Long
| Dim temp As Integer
| Dim endCount As Integer
-----------------------------------
If tabDirect <> NonTab Then 'If not tabbing, skip to end of sub
If tabDirect = Backwards Then
counter = Multipage.Value - 1
If counter < 0 Then
counter = Multipage.Pages.Count - 1
End If
cnt = Multipage.Pages(counter).Controls.Count - 2
-------------------------------------------------------------
| idWanted = 2
| endCount = Multipage.Value - 1
-------------------------------------------------------------
ElseIf tabDirect = Forwards Then
counter = Multipage.Value + 1
cnt = 0
-------------------------------------------------------------
| idWanted = 1
| endCount = Multipage.Value
-------------------------------------------------------------
End If
---------------------------------------------------------------------------
| For temp = 0 To endCount
| idWanted = idWanted + Multipage.Pages(temp).Controls.Count / 2
| 'Division by two since each page has an associated label for each textbox
| Next temp
|
| 'textArr is an array of textboxes on the form
| 'where textboxes were added in the order they appear on each page
| If textArr(idWanted).Name = enteredBox Then
---------------------------------------------------------------------------
'Only way for counter to equal Multipage.Pages.Count,
'is if tabbing forward off of last page.
'Desired result is to leave the multipage
If counter <> Multipage.Pages.Count Then
'Tabbing forwards: want first textbox, tabbing backwards: want last
If tabDirect = Backwards Then
cnt = Multipage.Pages(counter).Controls.Count - 2 ' skip over label
Else
cnt = 0
End If
Multipage.Value = counter
With Multipage.Pages(counter).Controls(cnt)
.SetFocus
.SelStart = 0
.SelLength = Len(.Value)
End With
'Fixing scollbar
If tabDirect = Backwards Then
Multipage.Pages(counter).ScrollTop = Multipage.Pages(counter).ScrollHeight
Else
Multipage.Pages(counter).ScrollTop = 0
End If
'Don't want to cancel when leaving first page backwards
If tabDirect <> Backwards Or counter <> Multipage.Pages.Count - 1 Then
Cancel = True
End If
Else
Multipage.Value = 0
Multipage.Pages(0).ScrollTop = 0
End If
--------------------
| End If
--------------------
End If
End Subhttps://stackoverflow.com/questions/48711648
复制相似问题