Learn VBA Code Part 12 RowSource For ComboBox in Userform
>> YOUR LINK HERE: ___ http://youtube.com/watch?v=Bp9GuPtERIg
In This Video I will Teach You Two Different Methods To Store Unique Values in Combobox Dropdown List.I will Also tell you difference Between These methods and when you Should use them. • #excelvba #excelvbatutorial #excelautomation #exceltutorial #dataentry • • ==== IMP Tutorials for Beginners ===== • Learn VBA Code Part 9 || Types of Loops and Their Uses • • Learn VBA Code Part 9 || Types of Loo... • Learn VBA Code Part 10 || Easy Code Module For Cumulative Values • • Learn VBA Code Part 10 || Easy Code M... • Learn VBA Code Part 11 || Update Data with Loops • • Learn VBA Code Part 11 || Update Data... • • ===============You Never Seen Before On YouTube ============================= • Fully Automatic Attendance Sheet in Excel Without VBA • • Fully Automatic Attendance Sheet In E... • Fully Automatic Attendance Sheet in Excel for Different Weekly OffDays • • Fully Automatic Attendance Sheet In E... • • ======================VBA Beginners Videos ============================= • Introduction of Excel VBA • • Introduction of Excel VBA || Types of... • Learn VBA Code Part 1 || VBA Tutorials for Beginners • Worksheet Codes • • Learn VBA Code Part 1 || VBA Tutorial... • Learn VBA Code Part 2 || VBA Tutorials for Beginners • Module Code • • Learn VBA Code Part 2 || VBA Tutorial... • Learn VBA Code Part 3 || VBA Tutorials for Beginners • Userform and It's Controlls • • Learn VBA Code Part 3 || VBA Tutorial... • Learn VBA Code Part 4 || VBA Tutorials for Beginners • How to create Your First Data Entry Form • • Learn VBA Code Part 4 || Create Your ... • Learn VBA Code Part 5 || Date Format Issue in Excel and VBA • How To write Date in Userform • • Learn VBA Code Part 5 || Date Format ... • Learn VBA Code Part 6 || Write Code for Save Data Button, • Error and Solution • • Learn VBA Code Part 6 || Write Code F... • • ======== Code for Extract Unique Values in ComboBox Dropdown List ======= • this code use in userform Initialize or Combobox Dropdown Button Event • Change Values According your Requirements • • Dim I, J As Long • Dim lrSH3 As Long • Dim MonthName As Boolean • ' Define the last row in column B • lrSH3 = Sheet3.Cells(Sheet3.Rows.Count, B ).End(xlUp).Row 'Your sheet Name and it's Lastrow • ' Define the Listcount is 0 • If Me.ComboBox4.ListCount = 0 Then • For I = 5 To lrSH3 • ' Check if MonthName already exists in ComboBox4 • MonthName = False • For J = 0 To Me.ComboBox4.ListCount - 1 • If Me.ComboBox4.List(J) = Sheet3.Cells(I, B ).Value Then • MonthName = True • Exit For • End If • Next J • ' If MonthName does not exist, add it to ComboBox4 • If Not MonthName Then • Me.ComboBox4.AddItem Sheet3.Cells(I, B ).Value • End If • Next I • End If
#############################
![](http://youtor.org/essay_main.png)