|28 days ago||5 months ago|
|Visual Basic .NET||VBA|
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?
Export-MS-Project-to-MS-Excel - Export tasks, Gantt chart and resources from MS Project to MS Excel. No additional software or installation required. Using build-in MS Project features (VBA).
EvilClippy - A cross-platform assistant for creating malicious MS Office documents. Can hide VBA macros, stomp VBA code (via P-Code) and confuse macro analysis tools. Runs on Linux, OSX and Windows.