Thanks Melone and Prex
I want to make non repeating validation list directly from original list without intermediate column of list. It will better if it could me made by custom function in VBA.
rodesh
I have a column list containing e.g.
Sunday
Sunday
Monday
Monday
Monday
Tuesday
....
...
Now I want to validate cell which shows list e.g.
Sunday
Monday
Tuesday
..
..
Without repeating values.
The main thing is That Userform1 of VBA refer to "Object" whereas Userform1 of cell A1 refere to "string" value so these are not comparable.The following is the simple code which would work for you.Assume you have three userforms.
Sub Excelform()
Select Case Cells(1, 1)
Case...