-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathTNAModule.bas
More file actions
37 lines (31 loc) · 788 Bytes
/
TNAModule.bas
File metadata and controls
37 lines (31 loc) · 788 Bytes
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
Attribute VB_Name = "TNAModule"
Sub dataform_show()
dataform.Show
End Sub
Sub statsform_show()
statsform.Show
End Sub
Sub toolbar()
Dim mytoolbar As CommandBar
Set mytoolbar = CommandBars.Add("Data Management")
With mytoolbar
.Position = msoBarFloating
.Visible = True
End With
Dim src As CommandBarControl, stats As CommandBarControl
Set src = mytoolbar.Controls.Add(Type:=msoControlButton)
With src
.FaceId = 1849
.OnAction = "dataform_show"
.TooltipText = "Search"
End With
Set stats = mytoolbar.Controls.Add(Type:=msoControlButton)
With stats
.FaceId = 3736
.OnAction = "statsform_show"
.TooltipText = "Statistics"
End With
End Sub
Sub toolbarclose()
Application.CommandBars("Data Management").Delete
End Sub