Hi
This is one of the commonest questions in this forum. Search the forum
for "list unique items in userforn".
regards
Paul

On Mar 8, 7:45*pm, Dargoon wrote:
Hi,

I'd like to ask you for a help. I create useform, to which I want to
"connect" list of customers. This list is in another excel spreadsheet
and consist of many data /lots of clients appears many times/. I wish to
see in the userform every client only once /without repetition/ - this
"window" can help users to choose appriopriate customer to create
certain reports.

I'll appreciate If someone has time and could help me to create proper code.

best regards,
Dargoon