|
|
|
Recalculate Macro and Progress Bar
0
A really simple way getting a FIFO Queue by using a array
1
Stefan0410
This module shows a really simple way to handle values in a LastIn-FirstOut (LIFO) stack by using array
- Push und Pop Functionality
- Push und Pop Functionality
0
A simple HashTable Function in VBA, incl. checking for unique key.
0
This script is a simple macro program which recalculate selected cells in Excel.
0
This is a function which generates random letters for password. Programers can use this at Microsoft Excel and so on.
7
This is a cool function that lets you save MySQL query data to an Excel spreadsheet. This is good for taking a backup or if you want to change a lot of information fast, then re-upload it.
I will use the config.php and class.mysql.php files from MySQL DB Class with Extras, so please look at those also.
I will use the config.php and class.mysql.php files from MySQL DB Class with Extras, so please look at those also.
5
Excel macro to group and count the number of items in a range of cells, delimited by the pipe character "|". It returns a summary of the items including a percent of total and count for each item found, plus a grand total of all items.
Currently limited to 100 items, simple becasue I didn't have the time to spend to get dynamic arrays to work.
Currently limited to 100 items, simple becasue I didn't have the time to spend to get dynamic arrays to work.
Sample Data:
--------------
cat|dog|bird
--------------
cat|bird
--------------
cat
--------------
frog
==================
OUTPUT from =total(A1:A4)
==================
42.9% - 3: cat
28.6% - 2: bird
14.3% - 1: dog
14.3% - 1: frog
---
7
2
This macro will add a footer to your Excel worksheets. I use this at work because every Excel spreadsheet I do has to have my department and initials in the footer. This macro checks to make sure you are the author of the workbook, and it will not overwrite an existing footer. Just place this code in your personal macro workbook in the ThisWorkbook object.
5
This is a complete Hash table implementation for Visual Basic 6 or Visual Basic for applications. It is a complete tutorial and explains exactly how a hashtable works and the design decisions that were made for this version.







