just-VBA Alternatives

just-VBA reviews and mentions

• Settings Management that moves with your workbook and supports custom settings by OS and / or User
  3 projects | /r/vba | 6 Dec 2023

  I'd be happy to answer questions if you have any. Did you download the demo file for the FunWithListObjects?

• How to enable very fast wildcard searches on large tables
  1 project | /r/excel | 25 Nov 2023

  The demo file can be downloaded from my github here: https://github.com/lopperman/just-VBA/blob/main/Misc/arraySearch.xlsx

• Quickest way to duplicate rows based on value in a column
  1 project | /r/vba | 23 May 2023

  I'm not the best at documenting -- but I've been working on that. If you want to keep an eye on things I build, just follow my just-VBA repo on github. You can also follow me on reddit if you want to see what I post about -- i tend to post a lot :-)

• Are you logging? If not, consider dropping this module into your project and you'll be good to start logging immediately
  2 projects | /r/vba | 22 May 2023

  To that end, I created the pbLogging.bas module. It's reasonably commented, but feedback is welcome on that. Once imported into your project, you can immediately start logging by calling the pbLog function:

• Simplify deleting User-Selected ListObject Rows. Handles sheet protection, non-contiguous selection, databodyrange boundary control
  1 project | /r/vba | 20 May 2023

  Download Functional Demo Workbook, or the code

• [Excel] autogenerate sheets for the entire month at the beginning of each month.
  2 projects | /r/vba | 14 May 2023

  author (c) Paul Brower https://github.com/lopperman/just-VBA

• Enable users to dbl-click a cell in a ListObject or regular range, and replace or clear all matching values in column, or fill blanks
  1 project | /r/vba | 9 May 2023

  Descriptions and example of recommended usage are available in the RangeUpdateUtil.xlsm file, which can be found in this github location

• Suffering with Excel for Mac? Get Parallels.
  1 project | /r/excel | 23 Apr 2023

  What are some of the things in excel that you 'suffered' on a Mac? I'm coming at this from a curiosity standpoint. I've built quite a bit of tools/libraries over the past few years for Excel/VBA. 100% of everything I've done is Mac and PC compatible (feel free to check my post history or my just-VBA github project). The only thing that's a bit tedious is working with custom User Forms, but it can still be done.

• A Fast and Simple Settings Management Module. Automatically sets everything up and works for PC or MAC
  3 projects | /r/vba | 15 Apr 2023

  To use in your project, import the 'pbSettings.bas' module, and the 'Dictionary.cls' class module (also available here). Calling a method will automatically set up the worksheet/listobject. (e.g. t ype '? pbSettings.KeyExists("Version")' in the Immediate Window)

• Map and Copy Rows from ListObjects or Range to a 'Master' ListObject or Range
  1 project | /r/vba | 11 Apr 2023

  Download Demo .xlsm File

• A note from our sponsor - InfluxDB
  www.influxdata.com | 24 Apr 2024

  Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality. Learn more →