|8 months ago||4 months ago|
|GNU General Public License v3.0 only||MIT License|
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
(VBA) Starting at B4 I want to count how many cells in row 4 until the cell saying "Grand Total" is reached.
1 project | reddit.com/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 | reddit.com/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 | reddit.com/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 | reddit.com/r/vba | 15 Jan 2022
Field Change Auditing between an Access database and Excel Calculation Engine
1 project | reddit.com/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 | reddit.com/r/vba | 15 Sep 2021
How would I do a find all type of thing in vba?
1 project | reddit.com/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:
Why is this email macro not working? (see code)
1 project | reddit.com/r/vba | 23 Jul 2021
This email class may be of use to you OP. Using it is super simple like so:
Programming to automate repetitive and tedious aspects of a job
1 project | reddit.com/r/learnexcel | 19 Jul 2021
As for data entry/manipulation and user-friendly interfaces, that would be a lesson on good UX practices, which you probably can find articles written about it by googling. Honestly, the most I can really offer you is code from my library that I use in all my projects.
Interested in some VBA? Visit my Github Repo for useful code snippets!
1 project | reddit.com/r/u_ViperSRT3g | 29 Jun 2021
What are some alternatives?
VBA-JSON-parser - Backus-Naur Form JSON Parser based on RegEx for VBA
VBA_personal - Library with VBA, used in multiple projects.
crypto_vba - An Excel/VBA project to communicate with various cryptocurrency exchanges APIs
geo_vba - A geographic toolkit/library for VBA, excel etc.
VBA-CSV-interface - The most powerful and comprehensive CSV/TSV/DSV data management library for VBA, providing parsing/writing capabilities compliant with RFC-4180 specifications and a complete set of tools for manipulating records, fields and files.
VBA-Better-Array - An array class for VBA providing features found in more modern languages
VBA-macros - Some VBA macros for personal use
VBAUnicodeTools - Tools for working with Unicode in the VB Editor
VBA-CSV - Fast and convenient CSV reading and writing for VBA and Excel spreadsheets.
wordle97 - Wordle for Word 97