GIFT FOR YOU!
105 GENERIC, HIGHLY USEFUL VBA FUNCTIONS SUPPORTING BUSINESS APPLICATIONS
5 GENERIC USER FORMS, WITH VBA CODE, FOR USER INTERACTION
Thousands of code lines, carefully crafted over 35 years, are yours as a gift from me. These functions power robust business solutions serving my customers.
Yes, your are getting all of these 105 functions for FREE!
Returns True if arr is a dimentioned array
Returns the index of varValue along lngMatchRowColIndex row (if intDimension=1)/column (if intDimension=2), in a 2-D array.
Returns the index (1-based) of varValue in arr.
Transpose a variant array.
Sums all numeric values in column intColIndex of 2D array. 1-D is rows.
Returns true if production flag is set.
Restores the application state to normal:
- Protect SheetToProtect (if passed)
- Protects the Workbook if in Production mode (see InProductoin function)
- Sets the calculation mode to Automatic
- Activates the Workbook events listener
- Restores the mouse cursoe to its default icon
- Turns screen updating on
Exports an Excel Table as a csv file.
Export all rows within Worksheet organized in columns and rows starting at cell A1.
Exports an array as a csv file.
Imports a csv file into an Excel table.
Imports a csv file into an Excel Worksheet.
5 more functions serving the above.
Deletes the file (if exists).
Returns the file name stripped off a full path.
Converts a file name into a valid Windows file name.
Deletes all files older than days specified.
Returns the available Disk Drives as a comma separated string, e.g.: C,D,F.
Move a file between folders.
Copy a file to another folder.
Checks if a file exists.
Presents a message in the bottom status bar.
Clears the bottom status bar.
Returns True if printer is turned on and ready.
Prints out a Worksheet if printer is ready.
Sets rows as repeating rows in PageSetup for printing.
Unprotects a Workbook.
Protects a Workbook.
Unprotects a single sheet.
Protects a single sheet
Unprotects all Worksheets in a Workbook.
Protects all Worksheets in a Workbook.
Formats a column of cells.
Formats a column of cells in a table.
Applies (or removes) WrapText to a range of cells.
Draws border around a range: sides, color, weight.
Apply formatting to a row of a report.
Applies fill and/or font color to a column(s) of cells.
Applies fill and/or font color to a column(s) of cells as a conditional formatting formula.
Clears content and formatting from all cells of a report.
Invokes the find (search) of Excel on the current Worksheet to find a text string.
Returns the Worksheet column letter of a column number (index).
Activate the startup Worksheet specified in the Settings.
Checks if a Worksheet-scope range name is defined.
Hides all Worksheets flagged with a Worksheet-scope range name.
Hide a single Worksheet.
Unhide a single Worksheet.
Checks if a Worksheet is currently hidden.
Checks if a Worksheets exists and visible.
Copies a Worksheet to a newly created Workbook.
Opens an Excel file if not already open.
Checks if a Workbook is currently open.
Create a new Worksheet.
Closes a Workbook.
Returns the logged-in Windows user name.
Returns the computer name running this application from the Windows system.
Returns the local PC country code (e.g. 1 = United States).
Returns the full path to the Windows temporary folder.
Pauses execution of the program for a specified number of seconds.
Add a new row to a table.
Deletes row of current cell within a table.
Adds a new row at the end of the table and fills its fields with Values array items.
Fills a row of Fields in a Worksheet with values.
Deletes a complete Worksheet row by its index.
Deletes a row from a Worksheet where a Key Value is matched on a Column of a table on that Worksheet.
Resizes a table by one row and clears content of remaining row.
Updates the column value of one or more rows in a table matching a column key value.
Resizes a table to a specifies number of rows and columns.
Returns the number of data rows in a table.
Returns the number of columns in a table.
Returns the Worksheet row in which a Key is matched on a specific Column of a given range, or creates a new row if not matched.
Adds a new row at the end of a table and returns the Worksheet row number of the newly added row.
Returns the Worksheet row in which a Key is matched on a Column of a given table.
Returns the Worksheet column in which a column header is found in a table.
Sorts a table in Ascending or Descending order.
Deletes rows of a table except first rows specified.
Clears contents of non-formula cells in a table and deletes all rows except the first one.
Returns a value within a table at the intersection of the table row index and table column name.
A Lookup implementation on a table.
Looks up a row in a table by a key value, and updates this row's cell in a specified column.
Loads all rows of a specific column in a table into an array.
Find & Replace in cells of a table column.
Resizes a table to fit the array rows and columns and throws the array data into the resized table.
Returns the table index row of the active cell.
Resets all filters of a table showing all table data.
Pops up a login dialog box to the user.
Pops up a message box with a single "Close" button and a warning icon.
Pops up a dialog requesting some input from the user.
Pops up a message box with a "Yes" and "No" buttons.
Pops up a message box with a single "Close" button and a confirmation icon.
Controls user input length in a text control on a user form.
Returns Worksheet name of active cell.
Returns value of active cell.
Returns Worksheet row of active cell.
Returns Worksheet column index of active cell.
Vlookup returning the value of intersection of current active cell row and a Worksheet column.
Hlookup returning the value of intersection of current active cell column and a Worksheet row.
Expands Excel data area to full screen.
Restore Excel data area to regular size.
Show or hide Worksheet rows and columns headings (numbers and letters).
Closes the Excel application or just the active Workbook if more are open).