Need in VBA Excel Multiforms. Disregards the \"documentation sheet\" part in the

Question

Need in VBA Excel Multiforms. Disregards the "documentation sheet" part in the instructions.

Link to Stats.xlsx:   https://docs.google.com/spreadsheets/d/1d3O77eFR6yCAgMaxgQbtPRqv0y0TT8SupulIrl1C4eA/edit?usp=sharing

I would appreciate if the answer is also in s sharable link to an excel file

VBA: Question 6: Create a multitab UserForm which has 2 tabs. Under a tab named Statistics and using the data found on the Stats.xlsx worksheet, allow the user to select the data and then display in a MsgBox these statistics: 1. The average of the selected data 2. The standard deviation of the selected data 3. The largest value in the selected data 4. The smallest value in the selected data 5. The median of the selected data Do not forget your run buttons and your documentation sheets

Explanation / Answer

The vbaProject.bin file is a binary OLE COM container. This was the format used in older xls versions of Excel prior to Excel 2007. Unlike all of the other components of an xlsx/xlsm file the data isn’t stored in XML format. Instead the functions and macros as stored as pre-parsed binary format. As such it wouldn’t be feasible to define macros and create a vbaProject.bin file from scratch (at least not in the remaining lifespan and interest levels of the author).

Instead a workaround is used to extract vbaProject.bin files from existing xlsm files and then add these to XlsxWriter files.

he vba_extract utility is used to extract the vbaProject.bin binary from an Excel 2007+ xlsm file. The utility is included in the XlsxWriter examples directory and is also installed as a standalone executable file:

Once the vbaProject.bin file has been extracted it can be added to the XlsxWriter workbook using the add_vba_project() method:

If the VBA file contains functions you can then refer to them in calculations using write_formula():

Excel files that contain functions and macros should use an xlsm extension or else Excel will complain and possibly not open the file:

It is also possible to assign a macro to a button that is inserted into a worksheet using the insert_button() method:

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.