Skip to content

AJ's Techie & Wacky World

  • ✨ AI Helper
  • 🎓 Courses
  • Excel & Office
    • Charts & Dashboards
    • Excel 365 & Dynamic Arrays
    • Excel for Finance
    • Excel for India
    • Excel Formulas
    • Excel Functions A–Z
    • Excel VBA
    • Formula Combos
    • Power BI & DAX
    • Power Query & Pivots
    • Python in Excel
    • Google Workspace
    • Outlook
    • PowerPoint
    • Word
  • Coding
    • Cloud & Servers
    • Dev Tools
    • Java
    • JavaScript
    • PowerShell
    • Python
    • R
    • Rust
    • SQL
    • VBA to Python Migration
  • Automation
    • AutoHotkey
    • Automation Basics
    • Office Scripts
    • Power Automate
    • Python Automation
    • SAP GUI Scripting
  • AI & ML
    • AI Agents & RAG
    • AI Agents & Workflows
    • AI Tools
    • Build Your Own LLM
    • Deep Learning
    • LLMs
    • Machine Learning
    • Prompt Engineering
    • Vibe Coding
  • ERP
    • Essbase
    • Oracle EPM Cloud
    • Oracle Smart View
    • SAP
    • Tally & Busy
    • Tax & Compliance
  • Tech Tips
    • Internet & Browser
    • Phone
    • Security & Privacy
    • Windows
    • Work Smarter
  • Wacky World
    • Fun Facts
    • History
    • Science
    • All Wacky Facts
  • Tools
    • Formula Lab
    • VBA Playground
    • Macro Recorder
    • VBA Challenges
    • SQL Playground
    • Shortcut Trainer
    • Date & Workday Calculator
    • EMI & SIP Calculator
    • Income Tax: Old vs New
    • GST Calculator
    • Regex Tester
  • About
    • Projects
    • Contact
  • 📲 Get App
Basics of VBA / Macros Chapter – 55 (Events Part-4)

5 Feb 2017 · Excel VBA · 1 min read

Basics of VBA / Macros Chapter – 55 (Events Part-4)

Below we will look at a program in Excel VBA that creates a footer before printing a workbook. Create a Workbook BeforePrint Event. Code…

Read article →
Basics of VBA / Macros Chapter – 54 (Events Part-3)

3 Feb 2017 · Excel VBA · 2 min read

Basics of VBA / Macros Chapter – 54 (Events Part-3)

Below we will look at a program in Excel VBA that highlights the row and column of the Active Cell (selected cell). This program…

Read article →
Basics of VBA / Macros Chapter – 32 (Loop Part-9)

2 Feb 2017 · Excel VBA · 3 min read

Basics of VBA / Macros Chapter – 32 (Loop Part-9)

Below we will look at a program in Excel VBA that removes duplicates. Situation: In column A we have 10 numbers. We want to…

Read article →
MEDIAN Function in Excel: The Middle Value

31 Jan 2017 · Excel Functions A–Z · 2 min read

MEDIAN Function in Excel: The Middle Value

Calculate the statistical median (exact middle value) of a numeric dataset, providing a realistic baseline unaffected by extreme outliers.

Read article →
Basics of VBA / Macros Chapter – 53 (Events Part-2)

31 Jan 2017 · Excel VBA · 1 min read

Basics of VBA / Macros Chapter – 53 (Events Part-2)

Code added to the Worksheet BeforeDoubleClick Event will be executed by Excel VBA when you double click a cell on a worksheet. Open the…

Read article →
Basics of VBA / Macros Chapter – 52 (Events Part-1)

28 Jan 2017 · Excel VBA · 2 min read

Basics of VBA / Macros Chapter – 52 (Events Part-1)

Events are actions performed by users which trigger Excel VBA to execute code. Workbook Open Event Code added to the Workbook Open Event will…

Read article →
Basics of VBA / Macros Chapter – 31 (Loop Part-8)

25 Jan 2017 · Excel VBA · 2 min read

Basics of VBA / Macros Chapter – 31 (Loop Part-8)

Below we will look at a program in Excel VBA that randomly sorts data (in this example randomly sorts names). Situation: We will declare…

Read article →
Basics of VBA / Macros Chapter – 50 (Time and Date Part-7)

23 Jan 2017 · Excel VBA · 3 min read

Basics of VBA / Macros Chapter – 50 (Time and Date Part-7)

Below we will look at a program in Excel VBA that sets the background color of tasks that are on schedule to green, and…

Read article →
Basics of VBA / Macros Chapter – 49 (Time and Date Part-6)

20 Jan 2017 · Excel VBA · 2 min read

Basics of VBA / Macros Chapter – 49 (Time and Date Part-6)

Below we will look at a program in Excel VBA that counts the number of year occurrences. Situation: Dates are in US Format. Months…

Read article →
Basics of VBA / Macros Chapter – 48 (Time and Date Part-5)

18 Jan 2017 · Excel VBA · 2 min read

Basics of VBA / Macros Chapter – 48 (Time and Date Part-5)

To execute a sub in Excel VBA after a specific time, use onTime, Now and the TimeValue function. First, place a sub into a…

Read article →
Basics of VBA / Macros Chapter – 30 (Loop Part-7)

17 Jan 2017 · Excel VBA · 3 min read

Basics of VBA / Macros Chapter – 30 (Loop Part-7)

Below we will look at a program in Excel VBA that sorts numbers. Situation: Place a command button on your worksheet and add the…

Read article →
Basics of VBA / Macros Chapter – 47 (Time and Date Part-4)

15 Jan 2017 · Excel VBA · 3 min read

Basics of VBA / Macros Chapter – 47 (Time and Date Part-4)

Below we will look at a program in Excel VBA that calculates the number of weekdays between two dates. Weekdays are: Monday, Tuesday, Wednesday, Thursday…

Read article →
Older posts
Newer posts
← Previous Page1 … Page103 Page104 Page105 … Page107 Next →

AJ's Techie & Wacky World

Curated by Atul Vij • © 2026 • All Rights Reserved

About Courses Free Tools Templates Privacy Policy Contact GitHub
Did you know?

Why? →