(ListBox)
, , :
: ( !) , :
2 (1- .., 2- ).
.
.
, C:\St\.xls (. 10‑10):
. 10‑10.
1) :
cmdOK
cmd
lst
2) frm__2_.
2 , , :
1) | Option Base 1 |
2) | Dim flag As Integer |
3) | Dim flag As Integer |
4) | Sub _2_() |
5) | Dim () As String |
6) | Dim () As String |
7) | Dim As Integer |
8) | Dim As Integer |
9) | On Error GoTo |
10) | '1. C:\St\.xls |
11) | Call ("C:\St\.xls") |
12) | If flag = 0 Then Exit Sub |
13) | '2. |
14) | Call ("") |
15) | If flag = 0 Then Exit Sub |
16) | '3. _ : |
17) | = 3 |
18) | = 0 |
19) | While Trim(Cells(, 2).Value) <> "" |
20) | If Trim(Cells(, 1).Value) = " " Then |
21) | = + 1 |
22) | ReDim Preserve (2, ) |
23) | (1, ) = _ Cells(, 2).Value |
24) | (2, ) = _ Cells(, 3).Value |
25) | End If |
26) | = + 1 |
27) | Wend |
28) | '4. : |
29) | ReDim (, 2) |
30) | For i = 1 To |
31) | (i, 1) = (1, i) |
32) | (i, 2) = (2, i) |
33) | Next i |
34) | '5. , 2- _ |
35) | : |
36) | With frm__2_.lst |
37) | .ColumnCount = 2 |
38) | .MultiSelect = fmMultiSelectMulti |
39) | .List = |
40) | End With |
41) | frm__2_.Show |
42) | Exit Sub |
43) | : |
44) | MsgBox " _ !", vbCritical, " " |
45) | End Sub |
1) | Sub () |
2) | Dim As String |
3) | Dim As String |
4) | flag = 1 |
5) | flag = 0 |
6) | '1. : |
7) | If Dir() = "" Then |
8) | flag = 0 |
9) | MsgBox " " & & " !", _ vbInformation |
10) | Exit Sub |
11) | End If |
12) | '2. : |
13) | = Dir() |
14) | '3. , : |
15) | For i = 1 To Workbooks.Count |
16) | If Workbooks(i).Name = Then |
17) | Workbooks(i).Activate |
18) | flag = 1 |
19) | Exit For |
20) | End If |
21) | Nexti |
22) | If flag = 0 Then _ Workbooks.Open Filename:= |
23) | End Sub |
|
|
1) | Sub () |
2) | Dim As String |
3) | ' : |
4) | flag = 0 |
5) | For i = 1 To Worksheets.Count |
6) | If Worksheets(i).Name = Then |
7) | flag = 1 |
8) | Exit For |
9) | End If |
10) | Nexti |
11) | If flag = 1 Then |
12) | Sheets().Select |
13) | Else |
14) | MsgBox " - " & _ & " !", vbExclamation, _ " " |
15) | Exit Sub |
16) | End If |
17) | End Sub |
:
1. , .
2. , .
3. , . J!
:
10 .