Learn Excel: Excel VBA

Here you’ll find useful Excel VBA macros and automation scripts for real-world use👇

How to Create an Invoice in Excel with a Database

1.Invoice Save DataBase Code File

2.Invoice User Form Code File

Customer Sheet Auto-Creation VBA

This VBA code creates a new customer sheet based on a predefined template.

Sub AddCustomerSheet()
    Dim templateSheet As Worksheet
    Set templateSheet = ThisWorkbook.Sheets("Customer_Template")
    ' More code here...
End Sub

Topic Name

How To Sort in Excel automatically VBA

Goto VBA Editor Press ALT F11

And Object Select Worksheet

and Code Here Copy and Paste Excel VBA

Const rng_sorting As String = "C:C"

Const rng_Dataset As String = "A:D"


Private Sub Worksheet_SeletionChange(ByVal Target As Range)


Dim tgrcol As Long
If Not Intersect(target, Range(rng_sorting)) is Nothing Then

tgrcol = Target.column
Columns(rng_dataset).Sort Key1:=Columns(tgrcol), _
Order1:=XlAscending, Header:=xlYes, _
OrderCustom:=1, MatchCase:=False, _
Orientation:=XlTopToBottom
End IF


End Sub

Final Code Preview Here