VBA-General Alternatives

VBA-General reviews and mentions

• Where/How do you take track of notes
  1 project | /r/vba | 16 Dec 2022

  Here's a code repo that I've had for years now.

• VBA Username and Password Regex (MS Access)
  1 project | /r/visualbasic | 2 Dec 2022

  You can view any updates to this function via github.

• [OUTLOOK/EXCEL/WORD] Easy way to add Context Menus/Right-Click Menus to VBA UserForms
  1 project | /r/vba | 2 Oct 2022

  But in any event, there's an API to check a window's class name (GetClassName) or you could just use u/sancarn 's Accessibility Inspector (link), or you can get the hWnd and otherwise control the appearance, dimensions and functionality of the Userform by using the Userform class by u/ViperSRT3g (link) or by using his WinAPI class (GetUFHandle).

• (VBA) Starting at B4 I want to count how many cells in row 4 until the cell saying "Grand Total" is reached.
  1 project | /r/excel | 18 Mar 2022

  What are you doing with this project overall? (Also you can view more of where those functions came from here)

• Can I create function to run a few lines of VBA code instead of typing the same code multiple times?
  1 project | /r/vbaexcel | 21 Jan 2022

  If the four lines of code are literally to identify the bottom left most cell of data on a sheet, then functions for that already exist. The GetLastRow function from that module would be the code you'd reuse.

• [WORD] [EXCEL] Can I build a tiny desktop application that can be a friendly-UI "splash page" basically for my templates?
  2 projects | /r/vba | 18 Jan 2022

  This would certainly be simplest with launching from a userform stored in Excel. You could make it more fancy and look like a standalone application with extra code libraries but they wouldn't be necessary.

• Harness the power of the WINAPI to improve your Userform design!
  1 project | /r/vba | 15 Jan 2022
• Field Change Auditing between an Access database and Excel Calculation Engine
  1 project | /r/vba | 5 Jan 2022

  Here's a module I use for generating hashes. It can handle SHA256/512 which is entirely overkill for this, but it's simple and easy. To generate a hash, concatenate all the fields of a record together and pass that to one of the SHA_String functions.

• General Git repo with vba code
  2 projects | /r/vba | 15 Sep 2021
• How would I do a find all type of thing in vba?
  1 project | /r/vba | 10 Aug 2021

  Ah, I ran into this problem years ago so I created the RangeFindAll function to do the work for me. It operates on the same idea as when you use CTRL+F to find a value on a worksheet. It loops through everything it finds and adds each cell to a range reference, then spits that out once it realizes that it has looped through all cells with that value. Here's an example of how simple it is to work with:

• A note from our sponsor - SaaSHub
  www.saashub.com | 19 May 2025

  SaaSHub helps you find the best software and product alternatives Learn more →