For Next Loop in Excel VBA part-2 | Excel VBA Lesson-11 | excel vba tutorial for beginners

  Рет қаралды 33,212

Computer Gyan Guruji

Computer Gyan Guruji

Күн бұрын

Пікірлер: 46
@salenakabobby-flowermen
@salenakabobby-flowermen 3 жыл бұрын
Bouath uttam Guru ji, from Fiji Islands.
@babydr4857
@babydr4857 2 жыл бұрын
Hello sir ! Namaskar. U had taught the VBA coding in a very nice, comprehensive. & impressive way except the several examples in each lesson seems made it incomprehensive up to some extent. Anyway, nice work done by you. Hats off to you & thanks a lot. You know softwares a lot, kindly keep teaching us in easier manner.
@muhammaddilshadshad2658
@muhammaddilshadshad2658 2 жыл бұрын
Boss ap ei dum super hoo Mn vba ke vedio bohat search kiya or dekha bi lekin mere ko asa vedio kahin ni mila jesa ap demo dety hooo Mero ko smjh ni aati mn apka dhanwad kese kroo Bs itna kahoon ga ap such mn gayan samundar hoo Boss asi vedio banty rahyn Vba coding user form etc🙏🙏🙏
@virendrahardiya2797
@virendrahardiya2797 Жыл бұрын
Sir aap, bahut badhiya sikha rahe han, bahut bahut dhanyawad 🙏🥳 Galtiyon se hi or bhi nayi barikiyan samajh aa jati hai, itna detail me samjhane k liye aapka aabhari 💓 hun
@santoshkiran5858
@santoshkiran5858 3 жыл бұрын
Guru ji you're next level mind blowing 👍👍👍
@techtrend3065
@techtrend3065 3 жыл бұрын
Nice Buht Allaaa
@nikanshukumar1
@nikanshukumar1 5 ай бұрын
Bahut Accha
@virendrahardiya2797
@virendrahardiya2797 Жыл бұрын
ये तब बहुत काम आयेगा जब शुरुआत कही बीच के सेल range से करनी पड़ती है 💓🤔🙏🥳
@satender7625
@satender7625 Ай бұрын
❤️
@LiaqatAli-qk8yp
@LiaqatAli-qk8yp 20 күн бұрын
Amazing
@manojk2890
@manojk2890 Жыл бұрын
🙏🙏🙏🙏🙏🙏🙏🙏
@ilyasofficial4730
@ilyasofficial4730 3 жыл бұрын
Good knowledge
@ajitvyas19
@ajitvyas19 8 ай бұрын
Nice
@MerajKhan-ew8pm
@MerajKhan-ew8pm Жыл бұрын
👍👍👍👍
@siddhanttiwari6513
@siddhanttiwari6513 8 ай бұрын
forloop7, we can use same as forloop6 and use offset with rowindex 2, it will remove the requirement to use such a lengthy code.
@abhishekverma2833
@abhishekverma2833 3 жыл бұрын
Hello Sir, I am working in a organisation as computer operator having medium knowledge of excel and I want to learn VBA Coding suggest me how and where I can start
@hsgusain2054
@hsgusain2054 3 жыл бұрын
Thanks Sir
@rooneychauhan7718
@rooneychauhan7718 3 жыл бұрын
Amazing video
@centuriongamers2674
@centuriongamers2674 2 жыл бұрын
For loop 6 main offset ko 2,0 set krdain loop7 easily work kray ga
@inayatullahkhan9065
@inayatullahkhan9065 2 жыл бұрын
Sub forloop7() Dim g As Byte Dim printval As Byte printval = 1 For g = 1 To 5 Cells(g, 1).Value = printval printval = printval + 2 Next g End Sub
@abhishekdas8503
@abhishekdas8503 3 жыл бұрын
Namaskar Sir , Sir aap apna Local window code area ke upar rakhiye
@nageshbabaladi5343
@nageshbabaladi5343 3 жыл бұрын
Sir vba codding spacial class dijia n
@vijaykaushik7524
@vijaykaushik7524 3 жыл бұрын
15:15 sir isme simply offset me hi 2,0 likh skte the na. vo to jyada easy ho jaata. itne sare valiable bhi nhi lgane pdte
@JungleLife-JF
@JungleLife-JF 2 жыл бұрын
Sahi hn vhai
@ksramani8712
@ksramani8712 Жыл бұрын
sir, how to work for str - data transfer specific (copy)from master sheet to other sheets under loop without riding same data instead to add only top up to other sheets(under loop) -finally no duplication data or riding in other sheets
@shortswaalebaba
@shortswaalebaba 3 ай бұрын
Hello sir please reply me we need your help for vba coding.
@tapeshaggarwal8974
@tapeshaggarwal8974 2 жыл бұрын
This video can be better.... Instead of printval, use offset to skip row for printing
@akoijamchittaranjan4410
@akoijamchittaranjan4410 Жыл бұрын
I can't use previous code next day ... asking user_defined type not defined
@dipakdave7085
@dipakdave7085 2 жыл бұрын
nse stock live prce ka vba coding bataye sir please
@ashutoshpandey6265
@ashutoshpandey6265 3 жыл бұрын
Sir VBA sikhne me kitna time lagega aur kitne videos aayenge?
@ComputerGyanGuruji
@ComputerGyanGuruji 3 жыл бұрын
BASIC KE 10 VIDEO OR LAGENGE
@vitocorleone4337
@vitocorleone4337 2 жыл бұрын
bahut hard tha😪
@mylearningplatform_easytoway
@mylearningplatform_easytoway 3 ай бұрын
सर सही बताऊं तो मेरा दिमाग की घड़ी हो गई इस बेसिक को समझने में ही आगे बड़े बड़े कोड को समझने में तो मेरे दिमाग का दही और दही का छाछ हो जाएगा। लेकिन क्या करूं सर मेरा बहुतमन है vba कोडिंग को सीखने का एडवांस्ड लेवल तक जहां मैं खुद कुछ अच्छा सॉफ्टवेयर तैयार कर सकूं 😒😒😒😒
@ismailafridi7028
@ismailafridi7028 3 ай бұрын
Simple g-1 instead of new var
@ksramani8712
@ksramani8712 Жыл бұрын
Each lesson over - you can suggest for practice test with link - and recommend for next,--------- --without practice ' Next or Do Until Loop' will not work - please suggest how to proceed
@muhammadrashid3307
@muhammadrashid3307 7 ай бұрын
sir subroutine 7 mein main ne aisay code kia accurate execute huwa Sub forloop7() Dim g As Byte Range("A1").Select For g = 1 To 10 ActiveCell.Value = g ActiveCell.Offset(2, 0).Select Next g End Sub
@saniyakousar2829
@saniyakousar2829 3 жыл бұрын
Sir aap ne ms word class karte samay Earning vides ki baat ki thi to aap ki Earning vides channel ka naam kya hai.aur sites k naam bhi batayiye sir main bahut sare videos per aap ko comments karke poch chuki hun aap ne jawab nahi diya.plz is bar dijiye.
@ComputerGyanGuruji
@ComputerGyanGuruji 3 жыл бұрын
earning video nahi kaha hoga youtube experience batane ka kaha to us channel ka naam "computer guruji" hai description me link diya hai
@soodvarun20
@soodvarun20 2 жыл бұрын
Range aur cells k video ka link Dijiye
@ComputerGyanGuruji
@ComputerGyanGuruji 2 жыл бұрын
kzbin.info/www/bejne/nJnPmYucj9CfZpY
@k.sandip6288
@k.sandip6288 3 жыл бұрын
Hi sir main aapke hi video se hi VBA sikh raha hun, abhi tak to samaj aa raha hian lekin aapne "option explicit" word kyu liya ye samaj nahi aaya, please kya aap bata sakate hain uska kya use hain.
@kksinha91
@kksinha91 2 жыл бұрын
Mujhe bhi "option explicit" samajh nahi aaya
@mushk3340
@mushk3340 Жыл бұрын
@k.sandip6288 @kksinha91 option explicit is liye lagaya jata hai ki agar variable spelling mistake ho to code error bata dega fir aap correction kar sakte ho Agar option explicit nahi lagaoge to code run kar jayega or wrong answer bhi de dega aap samajh bhi nahi paoge, Isko tools me jakar on kar sakte ho always on ho jayega.
@k.sandip6288
@k.sandip6288 Жыл бұрын
@@mushk3340 thank you Sir.
@rajeshpaul635
@rajeshpaul635 Жыл бұрын
It is bllired
@rajeshpaul635
@rajeshpaul635 Жыл бұрын
Video is not clear
Почему Катар богатый? #shorts
0:45
Послезавтра
Рет қаралды 2 МЛН
УЛИЧНЫЕ МУЗЫКАНТЫ В СОЧИ 🤘🏻
0:33
РОК ЗАВОД
Рет қаралды 7 МЛН
Their Boat Engine Fell Off
0:13
Newsflare
Рет қаралды 15 МЛН
Excel Macro - Pivot Table, Dynamic Range, Error Handling - Excel VBA Part 11
16:39
Learn Google Sheets & Excel Spreadsheets
Рет қаралды 59 М.
EASILY Make an Automated Data Entry Form in Excel
14:52
Kenji Explains
Рет қаралды 1 МЛН
VBA For Loop - A Complete Guide
12:36
Excel Macro Mastery
Рет қаралды 85 М.
Learn Excel VBA to Automate Anything
14:02
Kenji Explains
Рет қаралды 551 М.
Почему Катар богатый? #shorts
0:45
Послезавтра
Рет қаралды 2 МЛН