Please i need some help on this i am learner in this field. this is the issue i am having.
Screenshot (13).jpg



Sub Add_Product_List()


Dim sh As Worksheet
Set sh = ThisWorkbook.Sheets("Product_Master")

Dim I As Integer

Me.Cmb_Product.Clear
Me.Cmb_Product.AddItem ""

For I = 2 To Application.Worksheetsfunction.CountA(sh.Range("A:A"))
Me.Cmb_Product.AddItem sh.Range("B" & I)

Next I