Hi,
I am trying to use a the range Sheets("entitlement rules").Range("lgrpnh") as the rowsource for a combobox, but I want it to contain no duplicate values.
In the properties I have got the full list displayed but can't filter it and I haven't managed to get it to work using vba.
In access I would simply use 'Distinct' is there a similar function in excel?
The form is called "MPOLVEGROUP" and currently I have just used the rowsource property with:
Please Login or Register to view this content.
Bookmarks