Show TOC

Function documentationScenario 3: Menu Creation Using VBA Locate this document in the navigation structure

 

The user requires guidance on the process to close the financial month end. A workbook is created to provide a menu-like instruction. This workbook uses VBA macro assigned to buttons. The workbook also contains text to instruct the user on how to use the menu, for example click the button to invoke task.

  1. Initiate a monthly close

    Private Sub CommandButton1_Click()

    Application.Run ("MNU_eTOOLS_EXPAND”)

    Application.Run ("MNU_ eData_RUNPACKAGE")

    End Sub

  2. Enter the monthly financial data:

    Private Sub CommandButton2_Click()

    Application.Run ("MNU_eTOOLS_EXPAND”)

    Application.Run ("MNU_ eSUBMIT_OPENSTANDARD")

    End Sub

  3. Enter the adjustments:

    Private Sub CommandButton3_Click()

    Application.Run ("MNU_eTOOLS_EXPAND”)

    Application.Run ("MNU_eTOOLS_JOURNAL“)

    End Sub

  4. Enter the allocations:

    Private Sub CommandButton4_Click()

    Application.Run ("MNU_eTOOLS_EXPAND")

    Application.Run ("MNU_ eData_RUNPACKAGE")

    End Sub

  5. Review the consolidation:

    Private Sub CommandButton5_Click()

    Application.Run ("MNU_eTOOLS_EXPAND”)

    Application.Run ("MNU_ eANALYZE _OPENSTANDARD")

    Application.Run ("MNU_eSUBMIT_MODIFY")

    End Sub

  6. Update the monthly forecast:

    Private Sub CommandButton6_Click()

    Application.Run ("MNU_eTOOLS_EXPAND”)

    Sheets("Units").Select

    Sheets("Dollars").Select

    Application.Run ("MNU_eSUBMIT_SUBMIT")

    End Sub