Results 1 to 8 of 8

Thread: Make a simple report with VBA

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #6
    VBAX Expert shrivallabha's Avatar
    Joined
    Jan 2010
    Location
    Mumbai
    Posts
    744
    Location
    I do not know if you will find this solution as acceptable.

    1. Sheet Report is hidden where the solution provided (Pivot) above generates a report.

    2. Then using Listbox's Rowsource property gives the desired output.

    3. I know NO italian so I have changed one button (CmdInserisci) to show the userform. Press it and userform will appear. I don't know if it had something against it before.

    My explanation might be bad so I'm attaching the changed workbook.
    Attached Files Attached Files
    Regards,
    --------------------------------------------------------------------------------------------------------
    Shrivallabha
    --------------------------------------------------------------------------------------------------------
    Using Excel 2016 in Home / 2010 in Office
    --------------------------------------------------------------------------------------------------------

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •