CODEWITHSUNDEEP
excelvbscriptvba
S K padala
S K padala

Reputation: 251

how to limit excel column to limited number of words

I'm working with VBA, Excel. I have some set of words, say 10.

When I choose a particular column, then what ever I enter in that coulmn must be from those selected set of words.

It's like dropdown list but I really donot want to use dropdown list. This must be done to a column(or set of cells).

Upvotes: 1

Views: 480

Answers (1)

Poof
Poof

Reputation: 169

Hey you should be able to do it just like dropdown list but without in-cell dropdown option marked. Its an option that is automaticly marked when you validate column by list in validation form.

Upvotes: 2

Related Questions