Learn VBA Part 26 - Nested Do While Loop in VBA Hindi

Learn VBA in Hindi Part 26 - Nested Do While Loop in VBA

Learn to use Do While Loop in VBA
The Do While Loop repeats a block of code indefinitely while the specified Condition continues to be met

In this VBA Training video you will learn

1.Check Duplicate Value with VBA code
2.Manage Font Color with VBA code
3.Highlight cell content with Bold with VBA code

Learn Basic Excel Skills For Beginners || Part 1

10 Most Used Excel Formula
**Most Imporant Excel Formuls Tutorials**

Learn Vlookup Formula For Beginners in Excel

5 Excel Questions Asked in Job Interviews

Create Speedometer Chart In Excel

Learn the Basic of Excel for Beginners || Part 2

Create Pareto Chart In Excel

How to Create Dashboard in Excel

Excel Interview Questions & Answers

[nkdastudio]

This is the correct code.

Sub nesteddowileloop()

r = 31
C = r + 1
Do While Cells(r, 1) <> ""
C = r + 1
Do While Cells(C, 1) <> ""

If Cells(r, 1) = Cells(C, 1) And Cells(r, 2) = Cells(C, 2) Then
Cells(C, 4).Font.ColorIndex = 3
Cells(C, 4).Font.Bold = True
Cells(C, 4) = "Duplicate entry"
End If

C = C + 1

Loop
r = r + 1

Loop
C = C + 1

End Sub

[madhupkumar]

Sir jb VBA toturial pura ho jaye tb last video me ye bol dijiyega ki VBA class over ho gaya...
Or VBA k manue baar ka saara option ka function v bataiyega...

[inevergiveup]

Hi Sir, apne first video me kaha tha ki iss series me 100 tak videos honge.... please upload other videos as well.

[vijayjain]

color index(4)=Green
color index(5)=Blue
color index(5)= Pink



as you ask I am Giving answer
thanks for share video

[harendrasuccessstep]

Sir or vedeo upload karo please as soon as possible

[mangeshhande]

sir pls tell me, i did exact same still not getting the output, is there any setting we need to do in excel or any, ? aapne code run karke nahi dikhaya

[amiteducationworld]

Sir mujh dim ka concept mujh smajh nhi aaya pls pura clear karo

[suryajoshi]

sabhi video nhi milte h kuch videos delet kr diye h aapne lgta hai

[nikhilchavan]

hi,
how to user form create in excel

[Sandiipdilliwala]

sir baki 27 se 100 tak videos nahi banayi apne ?

[RajkumarSharma-qjfb]

Thank you so much ! I but that loop only look r=5 value, What about r=6, r=7, So, please tell about how to match all call each other?

And You`r question Answer is
4= Green
5= Blue
6= Yellow


Again Thanks !!

[neetshil]

hey my code is not working =. it doesn't has any error still its not giving me any output. What to do?? please help and thank you in advance!

[deepakkumarsen]

If there is number of entry is there, how do find duplicate with writing VBA code word by word..?

[parveenkumar-zoed]

vba ka ye basic course pura ho hya nhi