MultiSelect 和 Selected 属性示例

下例用 MultiSelect 和 Selected 属性来演示用户如何在列表框中选择一项或多项。用户通过选中选项按钮来指定选择的方法,然后在列表框中选择一项或多项。单击命令按钮可以在第二个列表框中显示所选的项。

窗体包含:

  • 名为 ListBox1 和 ListBox2 的两个列表框控件。
  • 名为 CommandButton1 的命令按钮。
  • 名为 OptionButton1 到 OptionButton3 的三个选项按钮控件。
Dim i

Sub UserForm_CommandButton1_Click()
    UserForm_ListBox2.Clear
    
    For i = 0 To 9
        If UserForm_ListBox1.Selected(i) = True Then
            UserForm_ListBox2.AddItem UserForm_ListBox1.List(i)
        End If
    Next

End Sub

Sub UserForm_OptionButton1_Click()
    UserForm_ListBox1.MultiSelect = 0
End Sub

Sub UserForm_OptionButton2_Click()
    UserForm_ListBox1.MultiSelect = 1
End Sub

Sub UserForm_OptionButton3_Click()
    UserForm_ListBox1.MultiSelect = 2
End Sub

Sub UserForm_Initialize()
    For i = 0 To 9
        UserForm_ListBox1.AddItem "Choice " & (UserForm_ListBox1.ListCount + 1)
    Next
    
    UserForm_OptionButton1.Caption = "Single Selection"
    UserForm_ListBox1.MultiSelect = 0
    UserForm_OptionButton1.Value = True
    
    UserForm_OptionButton2.Caption = "Multiple Selection"
    UserForm_OptionButton3.Caption = "Extended Selection"
    
    UserForm_CommandButton1.Caption = "Show selections"
    UserForm_CommandButton1.AutoSize = True
End Sub
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40