Create validation list of distinct values

**YasserKhalil** · 12-05-2014, 05:09 PM

Hello everybody
I have three columns A - B - C with values ..
I want in Range("E1") to create validation list of distinct values of the three columns using vba ??

**YasserKhalil** · 12-05-2014, 05:18 PM

I tried this code

Please Login or Register  to view this content.

But It doesn't work for me .. I don't know why?

**Debraj Roy** · 12-05-2014, 05:37 PM

Try this one..

Please Login or Register  to view this content.

**YasserKhalil** · 12-06-2014, 01:46 AM

Thank you very much Mr. Debraj Roy
You are very helpful

Create validation list of distinct values

LinkBack

Thread Tools

Rate This Thread

Display

Create validation list of distinct values

Re: Create validation list of distinct values

Re: Create validation list of distinct values

Re: Create validation list of distinct values

Thread Information

Users Browsing this Thread

Similar Threads

howto select distinct values from list

Create a Distinct Unique list for 2 Columns

[SOLVED] Create a distinct list based on other criteria

[SOLVED] Distinct List from Column of Values

Data Validation Returning only distinct values from a list

Bookmarks

Bookmarks

Posting Permissions