Full description of the file
Download a set of sample programmed code for an Excel file (VBA Macro Library)
Sample code programmed for Excel file (Macro Excel VBA library) today for you dear users in a collection ready to download that you can easily use in your Excel files
The set of codes in this file is as follows
This is exactly what it looks like, but it also works in VBA
This letter is the first letter in the input string
'Returns the selected part of the email address
'Receives the login ID of the current logged in user
'Receives the current active user domain entered
'This function searches for information about the user from the active list and returns one value each time
"This function searches the active directory for the user ID with a specific name
"These functions are for when the LDAP query returns a Dist name but we want the ID
'Splits the restricted string and returns part N.
11) RegisterDescriptionForUserDefinedFunction ()
"This function is only required once to record text and help categories for user-defined performance
'Adjust the row height for the whole sheet.
14) Custom_Copy sheet
"The procedure is to copy a source page to a new page and rename the new page.
15) Tab_ NewRename Custom
Follow the procedure to create a new sheet and rename the new sheet.
"The procedure is to copy a column to the" columnReferenceNumber "position and paste it into the" pastePositionReference "position.
"Sub-procedure To place a new column in the" targetColumnReference "column position on the" targetSheet "page, set the width to" targetColumnWidth "and the name to" targetColumnName ".
Add a comment to a cell.
The following is the procedure for rearranging columns from page to page.
A continuous column sequence and rearrangement sequence definitions in "formatReferenceSheetName" are expected to work properly for this subroutine.
This subroutine enters the formula 'formulaText' in the first cell of the text column (defined by 'targetSheet', 'columnReference' and 'rowOffset').
The formula is added to "lastRow". In addition, this function replaces the cells involved with their values after filling in, and removes the definitions of the formula.
Follow the procedure to convert the saved number as text to number.
Delete '' targetColumn 'in' targetSheet '.
The following procedure for creating and designing a pivot table as defined in the ReferenceSheet reference page format.
See "PR_1" and "PR_2" in "Excel_Reference_Sheet.xlsx" in the GitHub repository "excel-macro-vba-library".
Create a page (filter report) in the pivotTableName pivot table on the "pivotTableTargetSheet" page.
"Create a DataField in the" pivotTableName "pivot table on the" pivotTableTargetSheet "page, named" dataFieldName "and with the format" dataFieldFormat ".
'Set the number format of a specific column.
'Sort whole sheet' targetSheet by 'key1ColumnReference' in the order shown by 'order1Reference'
'Delete all rows where the column referenced by' indexColumnReference 'has duplicate values.
'Block the target page view. The division will be created in columnSplitLength and rowSplitLength.
'Enter the color in the range.
32) Custom_HideSheet (targetSheet as worksheet)
Activate the filter on a column of the target page. Filter for String value criteria.
'Remove all filters from the target page.
'Delete all visible rows in targetSheet. This should be used after filtering the current page for the information you want to delete.
36) Custom page - custom column
'Adjust the column width for the entire sheet.
'View file list
'Show folder list
'Check for file availability at address
'Find a string inside the text
'Check the directory in the address entered
'Right to time
'Open internet link
Dear user, the download offer is undoubtedly one of the most complete in this collection