Scribd
Upload
3 views2 pages

Excel VBA Module Menu Functions

The document contains a series of VBA (Visual Basic for Applications) subroutines for managing a coding module menu in an Excel workbook. It includes functions to open various forms for student data, deposits, withdrawals, and reports, as well as options to save and exit the application. Each subroutine ensures the worksheet is unprotected before showing the respective form and then protects it again afterward.

Uploaded by

Android3 Android3
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
3 views2 pages

Excel VBA Module Menu Functions

The document contains a series of VBA (Visual Basic for Applications) subroutines for managing a coding module menu in an Excel workbook. It includes functions to open various forms for student data, deposits, withdrawals, and reports, as well as options to save and exit the application. Each subroutine ensures the worksheet is unprotected before showing the respective form and then protects it again afterward.

Uploaded by

Android3 Android3
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

CODING MODUL MENU

Sub BukaDataSiswa()

[Link]

[Link]

[Link]

End Sub

Sub BukaSetoran()

[Link]

[Link]

[Link]

End Sub

Sub BukaPenarikan()

[Link]

[Link]

[Link]

End Sub

Sub Laporan()

[Link]

[Link]

[Link]

End Sub

Sub Simpan()

[Link]

End Sub
Sub Keluar()

Select Case MsgBox("Anda akan keluar dari Aplikasi" _

& vbCrLf & "Apakah anda yakin?" _

, vbYesNo Or vbQuestion Or vbDefaultButton1, "Keluar")

Case vbNo

Exit Sub

Case vbYes

End Select

[Link]

[Link]

End Sub

You might also like