Jump to content
Share your Excel moments ×
New Year wishes ×
Business Intelligence & Analytics for Digital Transformation
Share your Excel moments
New Year wishes

About This Club

Join the club and share tips and tricks of VBA macros for Excel

More Info

vba - excel programming

  1. What's new in this club
  2. Siddaraju G S
    Siddaraju G S joined the club
  3. Siddaraju G S
    Mobile.Model = iPhone 13 Mobile.Color = Blue
  4. Arittro
    Arittro joined the club
  5. Mohamed Fehmi Mahmoudi
    Mohamed Fehmi Mahmoudi joined the club
  6. mnmudau
    mnmudau joined the club
  7. Ajjas Shaikh
    Ajjas Shaikh joined the club
  8. Reddy Lakshmi Narayana
    Reddy Lakshmi Narayana joined the club
  9. comfortcool
    comfortcool joined the club
  10. Er. Yogesh Sutar
    Er. Yogesh Sutar joined the club
  11. Othmane Charaf
    Othmane Charaf joined the club
  12. Phethehile
    Phethehile joined the club
  13. arina
    arina joined the club
  14. Jean Bosco HABIMANA
    Jean Bosco HABIMANA joined the club
  15. Bec C
    Bec C joined the club
  16. Usman
    Sub cells_example() Range("J10").Cells(1, 1).Value = "Usman" Range("J10").Cells(1, 4).Value = "Usman" Range("J10").Cells(5, 3).Value = "Usman" Range("J10").Cells(8, 1).Value = "Usman" Range("J10").Cells(3, -2).Value = "Usman" Range("J10").Cells(1, -4).Value = "Usman" Range("J10").Cells(-3, -3).Value = "Usman" Range("J10").Cells(-5, 1).Value = "Usman" Range("J10").Cells(-2, 3).Value = "Usman" End Sub
  17. Usman
    Range("H4").Range("B1") Output Cell is I10
  18. Usman
    Assignment Done
  19. Usman
    Laptop.Make = "HP" Laptop.Color = "Grey"
  20. Usman
    Yes Developer tab is active in my Excel
  21. Usman
    Usman joined the club
  22. José Rafael
    José Rafael joined the club
  23. BENSON LUTHER
    BENSON LUTHER joined the club
  24. sukumar t
    sukumar t joined the club
  25. Nilesh R
    Nilesh R joined the club
  26. Fabiola Benoit
    Fabiola Benoit joined the club
  27. Chiamaka T. Okwara
    Chiamaka T. Okwara joined the club
  28. mwatata
    mwatata joined the club
  29. Sandip Waghmode
    Sandip Waghmode joined the club
  30. Harish S
    Harish S joined the club
  31. John Abass
    John Abass joined the club
  32. Victor1988
    Victor1988 joined the club
  33. Victor Parengkuan
    Victor Parengkuan joined the club
  34. SRIKANTH REDDY KALLU
    SRIKANTH REDDY KALLU joined the club
  35. Lalit Kumar Lakhotia
    Lalit Kumar Lakhotia joined the club
  36. AKSHAYA SAHU
    AKSHAYA SAHU joined the club
  37. Supachai Suddhipad
    Supachai Suddhipad joined the club
  38. Dinesh N
    Dinesh N joined the club
  39. Jorge Martins
    Jorge Martins joined the club
  40. Bongani
    Bongani joined the club
  41. Kedir Mohammed Abdela
    Kedir Mohammed Abdela joined the club
  42. Lappell
    Lappell joined the club
  43. Najib Gzouly
    Najib Gzouly joined the club
  44. James Harrod
    James Harrod joined the club
  45. KrekgsICT
    KrekgsICT joined the club
  46. Shiva Saxena
    Shiva Saxena joined the club
  47. Falmata Kitata
    Falmata Kitata joined the club
  48. Isaac Owiredu Essilfie
    Isaac Owiredu Essilfie joined the club
  49. Jasa
    Jasa joined the club
  50. Bab B
    Bab B joined the club
  51. shahbaz shaikh
    shahbaz shaikh joined the club
  52. Syeda
    Syeda joined the club
  53. Amarjeet
    Amarjeet joined the club
  54. Moonyeen Olmedo, PMP
    Moonyeen Olmedo joined the club
  55. Prisca
    Prisca joined the club
  56. Vlado Markovic
    Vlado Markovic joined the club
  57. Billy jones
    Billy jones joined the club
  58. Saurabh Jain
    Sub word_excel_multitable() Dim xlApp As Excel.Application Dim xlBook As Excel.Workbook Dim xlSheet As Excel.WorkSheet Set xlApp = CreateObject("Excel.Application") xlApp.Visible = True Set xlBook = xlApp.Workbooks.Add Set xlSheet = xlBook.Worksheets(1) rn = 0 cn = 0 For Each t In ActiveDocument.Tables For Each r In t.Rows For Each c In r.Cells xlSheet.Range("A1").Offset(rn, cn).Value = Left(c, Len(c) - 1) cn = cn + 1 Next c cn = 0 rn = rn + 1 Next r rn = rn + 2 Next t End Sub The code has to be pasted in module of word document Set reference for Excel object library in word so that word can write in Excel Click Tool > References
  59. Kashmira
    program done. It was nice.
  60. Kashmira
    seen entire video.
  61. Kashmira
    Done finding Perimeter and radius
  62. Kashmira
    fantastic. looking forward to learn more.
  63. Kashmira
    Done filling names in highlighted cell. It was interesting.
  64. Kashmira
    The output cell is I10
  65. Dan
    laptop.make = "Dell" laptop.touchscreen = TRUE
  66. Sudhir Singh Patyal
    i have done my assignment
  67. Kashmira
    Done my assignment.
  68. Kashmira
  69. Kashmira
    Excited to learn more and implement in my work. You are teaching it very well.
  70. Kashmira
    labtop.color="silver" labtop.processor="ryzen"
  71. Saurabh Jain
    Learn how to count, sum and display running totals
  72. Saurabh Jain

    Version 1.0.0

    8 downloads

    Two macro files
  73. Saurabh Jain
    VBA Tutorial 14 : For loop examples to read data write data & transform data
  74. Saurabh Jain

    Version 1.0.0

    1 download

    Two files Transform data has two sheets in which one is assignment
  75. Saurabh Jain
    Download VBA code
  76. Saurabh Jain

    Version 1.0.0

    4 downloads

    For loop examples Profit loss example
  77.  


×
×
  • Create New...