↓ Skip to Main Content

Excelabcd

Main Navigation

  • Excel functions
    • Excel Functions
    • Exercise
      • COUNT Functions Exercise
      • SUM Functions Exercise
      • LOOKUP Functions Exercise
  • Excel Features
    • Protect Workbook
    • Hyperlink
    • Text to Columns
    • Freeze Panes
    • Conditional Formatting
    • Charts
    • PivotTable
    • Filter
    • Data Validation
    • Format Cells
  • Excel++
    • Shortcuts
    • 100+ formulas
    • Short Tips
    • Free Sample Excel Data
    • Excel Templates
      • Calculator Templates
      • Misc Templates
  • VBA
    • What is VBA?
    • Learn VBA step by step
    • Posts related VBA
  • Blog
  • Buy Resources
    • Buy Ebook
    • Buy Premium Templates
  • Excel Courses
    • Basic Excel Course

Category: VBA and Macro

Lesson#195: How to make a Basic calculator in VBA

By Puspendu Roy Karmakar Posted on January 22, 2023 Posted in VBA and Macro
Lesson#195: How to make a Basic calculator in VBA

To create a calculator in Microsoft Excel using Visual Basic for Applications (VBA), you can follow these steps: This code will prompt the user to enter two numbers, add them together, and display the result in a message box.

Lesson#194: Make an area calculator for Triangles, Rectangles, and Circle in VBA

By Puspendu Roy Karmakar Posted on January 22, 2023 Posted in VBA and Macro
Lesson#194: Make an area calculator for Triangles, Rectangles, and Circle in VBA

To create an area calculator in Visual Basic for Applications (VBA) that can calculate the area of a triangle, rectangle, or circle, you can use the following code: This code defines a command button that, when clicked, prompts the user …

Lesson#194: Make an area calculator for Triangles, Rectangles, and Circle in VBA Read more »

Lesson#192: Automating Excel Tasks with VBA Macros

By Puspendu Roy Karmakar Posted on January 17, 2023 Posted in VBA and Macro
Lesson#192: Automating Excel Tasks with VBA Macros

Excel is a powerful tool for data analysis and management, but it can also be time-consuming to perform repetitive tasks. This is where VBA macros come in. VBA (Visual Basic for Applications) is a programming language that allows you to …

Lesson#192: Automating Excel Tasks with VBA Macros Read more »

Lesson#191: A macro to auto-format and organize data in an Excel

By Puspendu Roy Karmakar Posted on January 16, 2023 Posted in VBA and Macro
Lesson#191: A macro to auto-format and organize data in an Excel

Excel is a powerful tool for organizing and analyzing data, but it can be time-consuming to manually format and reorganize large sets of data. Fortunately, Excel’s built-in Visual Basic for Applications (VBA) programming language allows you to automate many of …

Lesson#191: A macro to auto-format and organize data in an Excel Read more »

Lesson#190: Continuously autosave the workbook with VBA

By Puspendu Roy Karmakar Posted on January 13, 2023 Posted in VBA and Macro
Lesson#190: Continuously autosave the workbook with VBA

To create a program in Visual Basic for Applications (VBA) that continuously saves an Excel worksheet at a specified interval, you can use the following code: This code defines a subroutine called AutoSave that continuously saves the active workbook (i.e., …

Lesson#190: Continuously autosave the workbook with VBA Read more »

Lesson#189: Make a digital clock with VBA

By Puspendu Roy Karmakar Posted on January 1, 2023 Posted in VBA and Macro
Lesson#189: Make a digital clock with VBA

In this article, we shall learn a VBA code to make a digital clock. To create a program in Visual Basic for Applications (VBA) that displays a clock in an Excel worksheet, you can use the following code: This code …

Lesson#189: Make a digital clock with VBA Read more »

Lesson#187: VBA program to shutdown PC

By Puspendu Roy Karmakar Posted on December 29, 2022 Posted in VBA and Macro
Lesson#187: VBA program to shutdown PC

Here is an example of a VBA program that you can use to shut down a Windows PC when a button is clicked: This program uses the Shell function to execute the shutdown command with the -s and -t 0 …

Lesson#187: VBA program to shutdown PC Read more »

Lesson#185: How to make a digital clock with VBA

By Puspendu Roy Karmakar Posted on December 28, 2022 Posted in VBA and Macro
Lesson#185: How to make a digital clock with VBA

In this post, we shall learn a simple to make a digital clock with VBA on your excel sheet. Now paste this VBA macro that you can use to create a digital clock on your worksheet, To use this macro, …

Lesson#185: How to make a digital clock with VBA Read more »

Lesson#184: Entered value divided by 100 with a button in VBA

By Puspendu Roy Karmakar Posted on December 28, 2022 Posted in VBA and Macro
Lesson#184: Entered value divided by 100 with a button in VBA

Here I shall show how entered value can be divided by 100 with a button in VBA. Here is the VBA macro that will automatically divide the value of the active cell by 100 when a command button is clicked: …

Lesson#184: Entered value divided by 100 with a button in VBA Read more »

Lesson#183: Insert zeroes in all empty cells in a selected range with VBA

By Puspendu Roy Karmakar Posted on December 28, 2022 Posted in VBA and Macro
Lesson#183: Insert zeroes in all empty cells in a selected range  with VBA

Here we are going to learn a VBA code to insert zeroes in all empty cells in a selected range. Here is your VBA macro code: To use this macro, select the range that you want to check for empty …

Lesson#183: Insert zeroes in all empty cells in a selected range with VBA Read more »

Posts pagination

Previous 1 2 3 4 5 Next
Microsoft365 for Business

AND CALCULATOR CHART CONDITIONAL FORMATTING COUNT COUNTBLANK COUNTIF COUNTIFS DATA VALIDATION DATE DAY FILTER FIND FORMAT CELLS HOUR IF IFERROR INDEX LEFT LEN MATCH MAX MID MIN MINUTE MOD MONTH NOT NOW PIVOTTABLE PROTECT SHEET recover RIGHT ROUND SECOND SHORTCUTS SUBSTITUTE SUM SUMIF SUMIFS TEXT TEXT TO COLUMNS TODAY VLOOKUP YEAR

Footer Menu

  • Home
  • About
  • Contact
  • Privacy Policy
Copyright © 2025 Excelabcd | Powered by Responsive Theme
Loading…