Introduction to Excel VBA | Excel VBA series lesson-1| Excel VBA Beginners tutorial in hindi

  Рет қаралды 278

program master

program master

Ай бұрын

Welcome to the first part of our VBA Programming Tutorial for Beginners series! 🚀 In this video, we dive into the basics of Visual Basic for Applications (VBA), the powerful programming language used to automate tasks in Microsoft Office applications like Excel, Word, and Access.
🔍 What you'll learn in Part 1:
What is VBA and why you should learn it
Setting up the Developer tab in Excel
Introduction to the VBA Editor
Writing your first VBA macro
🌟 Whether you're looking to streamline repetitive tasks, create complex automation solutions, or just expand your programming skills, this tutorial is the perfect starting point.
👍 Don't forget to like, comment, and subscribe for more VBA tutorials!
💬 Have questions? Drop them in the comments below and I'll do my best to help!
#VBA #VBATutorial #ExcelVBA #Programming #Automation #ExcelTutorial

Пікірлер: 9
@AbhishekPathak-zn3vf
@AbhishekPathak-zn3vf Ай бұрын
Nice way of teaching ...
@ProgramMaster338
@ProgramMaster338 Ай бұрын
Sukriya 😊
@user-dy6em2ue6v
@user-dy6em2ue6v Ай бұрын
Nice sir❤😊
@ProgramMaster338
@ProgramMaster338 Ай бұрын
Thank you 😊
@jitendramahapatra1239
@jitendramahapatra1239 Ай бұрын
Series wise upload kijiye sir please Support hum karenge
@ProgramMaster338
@ProgramMaster338 Ай бұрын
Meri Puri Kosis rahegi ki aap logo ko series wise video ....Keep supporting sir.
@jitendramahapatra1239
@jitendramahapatra1239 29 күн бұрын
@@ProgramMaster338 okay sir
@dipanshusrivastav1888
@dipanshusrivastav1888 Ай бұрын
Dear sir please help Please note that I have an excel workbook which has four sheets Jan, Feb, Mar, Apr, the data in these four sheets is different columns, how can I marge these 4 sheets in one singel sheet on different workbook threw vba pls help
@ProgramMaster338
@ProgramMaster338 Ай бұрын
Sub CombineSheets() Dim ws As Worksheet Dim combinedSheet As Worksheet Dim lastRow As Long, combinedLastRow As Long Dim sheetName As String ' Add a new sheet to store combined data Set combinedSheet = ThisWorkbook.Sheets.Add(After:= _ ThisWorkbook.Sheets(ThisWorkbook.Sheets.Count)) combinedSheet.Name = "MergedData" ' Loop through each sheet in the workbook For Each ws In ThisWorkbook.Worksheets ' Skip the combined sheet itself If ws.Name combinedSheet.Name Then ' Get the last row of data in the combined sheet combinedLastRow = combinedSheet.Cells(Rows.Count, "A").End(xlUp).Row ' Get the sheet name sheetName = ws.Name ' Loop through each row of data in the current sheet For lastRow = 1 To ws.Cells(Rows.Count, "A").End(xlUp).Row ' Copy data to the combined sheet combinedSheet.Cells(combinedLastRow + lastRow - 1, 1).Value = sheetName ws.Rows(lastRow).Copy Destination:=combinedSheet.Rows(combinedLastRow + lastRow - 1) Next lastRow End If Next ws MsgBox "All sheets combined successfully!", vbInformation End Sub This code is generally used to combine your sheet in one sheet automatically with named merged cell. I hope you will get your questions answer .... We will discuss this topics in our upcoming class .. Keep supporting us.. Thank You
Excel VBA Beginner Tutorial
2:10:31
Learnit Training
Рет қаралды 5 МЛН
YouTube Automation With AI | YouTube Automation Step By Step
24:56
Tube Sensei
Рет қаралды 542 М.
Microsoft  Excel for Free - Data Analysis -  Lesson 1 || in Urdu || 168
14:20