Friday, June 12, 2020

AUTOMATIC CALCULATION IN EXCEL BY VB (VISUAL BASIC) COADING



Vb (Visual Basic) Ab Apko Thoda Basic Jankari Visual Basic Ki Bhi De Deni Chahiye To Me Apko Wahi De Raha Hu Chlye Samajhte Hai

(To Kya Apne Vb Ka Use Kabhi Kya Hai Agar Nahi To Aj Me Apko Vb Ka Use Karna Sikhaunga Chalye Shuru Karte Hai)

Dosto Ham Ek Excel Ki Sheet Me Total Ka Ek Coading Lagate Hai To Ye Raha Sheet Isme Hum Automatic Calculate Karne Ka Coading Banayenge Jaha Apko Automatic Calculation Milegi Samajh Lete Hai Kuch

  

To Ye Hai Excel Ki Sheet Isme Hamne  Three Column Me Color Dya Hai Ise Samajh Lete Hai ( Yellow Column Wale Me Hum Value Dalenge Jise Sum Karana Hai) Aur Green Wale Me Result Automatic Ayega (Vb Open Sheet Select Then Inter Coading) As It

Sub Aa()

'Calculate Total Field

Dim A, B, C

A = Range("A1")

B = Range("B1")

C = A + B

Range("D1").Value = C

End Sub

(Ye Jo Mene “Aa” Coading Name Dya Hai Ise Ap Apne Hisab Se Koi Bhi Name De Sakte Ho) Ye Raha Vb Coading Box

 

Ab Excel Ki Sheet Me Jake Yellow Pe Koi Bhi Number Likho Automatic Calculate Ho Jayega Isi Tarah Se Ap Automatic Calculation Field Banayenge Bina Formula Lagaye

 



DOSTO YE CLASS CONTINUE JOIN KARTE RAHO AUR SABHI KO YE FREE CLASS KE BARE ME BATAO TAKI SABHI  SIKH SAKE AUR KOI PROBLEM ATI HE TO MUJHE COMMENT JARUR KARNA  (PLS 🙏🙏SHARE KARNA AUR MUJHE FOLLOW JARUR KARNA )


APKA MERE PAGE PE ANE KE LYE DHANYAWAD 🙏🙏🙏🙏 

LINK :- ADVANCEBANO.BLOGSPOT.COM
BY-AAKASH

 

No comments:

Post a Comment

THANKS FOR YOUR SUPPORT

Data copy paste on two another sheet with add row in google sheet by script

 function copyDataWithinWorkbook() {   var sourceSheetName = "Dashbord"; // Replace with the name of the source sheet   var target...