A collection of sample programmed code for an Excel file (VBA Macro Library)

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

1) WorksheetExists

2) CopyRowAboveAndInsert

3) ProperX

This is exactly what it looks like, but it also works in VBA
This letter is the first letter in the input string

4) Email_part

'Returns the selected part of the email address

5) current_user

'Receives the login ID of the current logged in user

6) current_user_domain

'Receives the current active user domain entered

7) get_user_info

'This function searches for information about the user from the active list and returns one value each time

8) get_user_id_from_difinguished

"This function searches the active directory for the user ID with a specific name

9) Receive_user_from_mail

"These functions are for when the LDAP query returns a Dist name but we want the ID

10) ReturnNthPartOfString

'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

12) Custom_GetLastRow

13) Custom_SetRowHeightSheet

'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.

16) Custom_CopyPasteColumn

"The procedure is to copy a column to the" columnReferenceNumber "position and paste it into the" pastePositionReference "position.

17) Custom_InsertRenameColumn

"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 ".

18) Custom_AddComment

Add a comment to a cell.

19) Custom_RearrangeColumns

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.

20) Custom_EnterFormulaAndFillDown

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.

21) Custom_ConvertNumberSavedAsText

Follow the procedure to convert the saved number as text to number.

22) Custom_DeleteColumn

Delete '' targetColumn 'in' targetSheet '.

23) Custom_CreatePivotTable

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".

24) Custom_PivotTableAddField

Create a page (filter report) in the pivotTableName pivot table on the "pivotTableTargetSheet" page.

25) Custom_PivotTableAddDataField

"Create a DataField in the" pivotTableName "pivot table on the" pivotTableTargetSheet "page, named" dataFieldName "and with the format" dataFieldFormat ".

26) Custom_SetColumnNumberFormat

'Set the number format of a specific column.

27) Custom_SortSheetByColumn

'Sort whole sheet' targetSheet by 'key1ColumnReference' in the order shown by 'order1Reference'

28) Custom_RemoveDuplicates

'Delete all rows where the column referenced by' indexColumnReference 'has duplicate values.

29) Custom_FreezeView

'Block the target page view. The division will be created in columnSplitLength and rowSplitLength.

30) Custom_DeleteSheet

'Delete targetSheet.

31) Custom_ColorRange

'Enter the color in the range.
    
32) Custom_HideSheet (targetSheet as worksheet)

'Hide tab.

33) Custom_ColumnFilter

Activate the filter on a column of the target page. Filter for String value criteria.

34) Custom_ReleaseFilter

'Remove all filters from the target page.

35) Custom_DeleteVisibleRows

'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.

37) Custom_InsertRenameColumn

38) BrowseForFile

'View file list

39) BrowseForFolder

'Show folder list

40) Copy

'Copy files

41) FileExists

'Check for file availability at address

42) FindString

'Find a string inside the text

43) FolderExists

'Check the directory in the address entered

44) FullAutomationExamples

45) GetDate

'Right to time

46) GetFileName

47) IsWbOpen

48) Log

49) Mail

50) OpenURL

'Open internet link

51) SheetExists

52) Zip

'Zip

Dear user, the download offer is undoubtedly one of the most complete in this collection