Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
''Create a menu and call it mnuPop
''The top menu's Visible = False
''Enter your menus
''This can be done on the fly, but for sake of
''brevity, I'll show my own examples.
''Each Index of the menu calls a different
''set of procedures, as shown in the example
''Although I don't show these procedures, you
''can probably figure out what each routine does.
''============================================
''This procedure ascertains which menu was clicked
Private Sub mnuPop_Click(Index As Integer)
Select Case Index
Case 0
Unload Me
Case 1
BegDate = Start2
EndDate = End2
OpenXL
OpenSheets
SaveAsFile
QuitXL
'SendEMail
Case 2
BegDate = Start1
EndDate = End1
OpenXL
OpenSheets
SaveAsFile
QuitXL
'SendEMail
Case 3
Visible = True
End Select
End Sub
''This procedure checks to see what button was pushed
Private Sub ListView1_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
If Button = 2 then ''Right button clicked
Me.PopupMenu mnupopup
End if
End Sub
Private Sub ListView1_MouseDown(Button As Integer, Shift As Integer, x As Single, y As Single)
If Button = 2 Then PopupMenu mnuName
End Sub
Private Sub mnuName_Click()
MsgBox ListView1.SelectedItem.Text
End Sub
Private Sub Form_MouseUp(Button As Integer, Shift As Integer, X As Single, Y As Single)
If Button = vbRightButton Then
PopupMenu Form1.mnuItem1
End If
End Sub