Hi all,

i have a button on a worksheet that when clicked goes through a column and returns a unique list that i use in data validation list (See below)

however what i would like to do is apply that same theory to a button on the userform as i have a combobox on the userform that has the same data in as the combobox on the sheet

Sub UniqueTrucks()
2: '
3: ' UniqueDvrNames Macro
4: ' Filter Uniqe Names
5: '
6: ' Keyboard Shortcut: Ctrl+Shift+Q
7: '
8:     Application.CutCopyMode = False
9:     Application.CutCopyMode = False
10:     Range("G9:G99999").AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Range( _
        "A9"), Unique:=True
End Sub