Skip to content
Paul Brower edited this page Dec 29, 2024 · 25 revisions

VBA Library - MAC and PC Compatible


The VBEUtil-v1-XXX.xlsm file has all the utility code I've ever created. Documentation and sample worksheets are under development, however all code is functional and 100% MAC and PC compatible.




Current Active Project: VBA CopyRight

Currently working on a library for all things 'copy/paste', check out the Wiki page


Some 'VBA Utility' modules, but this repo is focused on Creating Clean User Experiences with highly optimized code that run equally well whether on a MAC or a PC.

Contains fully functional demos and examples for many features and concepts.

I've experimented with creating some custom frameworks, open to discussion, collaboration.

Hash table demo


Check out the Eventless Addin


Check out the pbPicklist

  • Pushed out 7/3/2022


Part of a custom framework that enables:

  1. Running Code - When, and Where
  2. Navigation - Support for autoted worksheet protect, and visibility
  3. System State - Automated Management with override for ensuring clean and fast code execution, navigation, and user experience.

A Worksheet that informs users the app is busy, while lacking controls that would possibly interfere with the app.

** An Worksheet that analyzes, categorizes, and documents all the formulas in your workbook. Even the hidden ones, on the 'VeryHidden' sheets, that you now know are a real thing.