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

Поделиться
HTML-код
  • Опубликовано: 22 июн 2024
  • 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 13 дней назад +2

    Nice way of teaching ...

  • @user-dy6em2ue6v
    @user-dy6em2ue6v 13 дней назад +2

    Nice sir❤😊

  • @jitendramahapatra1239
    @jitendramahapatra1239 10 дней назад +2

    Series wise upload kijiye sir please
    Support hum karenge

    • @ProgramMaster338
      @ProgramMaster338  10 дней назад +2

      Meri Puri Kosis rahegi ki aap logo ko series wise video ....Keep supporting sir.

    • @jitendramahapatra1239
      @jitendramahapatra1239 9 дней назад +1

      @@ProgramMaster338 okay sir

  • @dipanshusrivastav1888
    @dipanshusrivastav1888 10 дней назад +1

    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  10 дней назад

      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