how to limit excel column to limited number of words -


i'm working vba, excel. have set of words, 10.

when choose particular column, ever enter in coulmn must selected set of words.

it's dropdown list donot want use dropdown list. must done column(or set of cells).

hey should able dropdown list without in-cell dropdown option marked. option automaticly marked when validate column list in validation form.


Comments