I have a userform with some comboboxes and commendbuttons, one of the comboboxes named "cmb_Name"
In Sub UserForm_Initialize, I have below peace of code to show the suppliers names in the combobox
Dim rngName As Range
Dim ws As Worksheet
Set ws = Sheet8
For Each rngName In...