CODEWITHSUNDEEP
vbaexcelvalidation
aaa
aaa

Reputation: 858

Excel - 2 data validation in the same cell

I want to combine 2 data validation into one cell. I can do it with separate cell, but had no idea on how to combining them.

First Validation: a list contains certain options for user to choose, and an others if it is not inside the list.

When Others is being selected, User can input their own data.

First Validation Setting

First Validation Setting

Second Validation: a cell that needs to starts with a certain format, else error message will appear. e.g. users can are only to allow to input in this format ABC xxxxx

Second Validation Setting

Second Validation

I want to combined the list validation and the custom validation to one cell F2. So users can choose either the options given, or choose other and input the data they want, but the format must be ABC xxxx.

Any suggestions and helps are appreciated. Thanks in advance

Upvotes: 1

Views: 636

Answers (1)

aaa
aaa

Reputation: 858

Thanks @pnuts & @ YowE3K, with the reference from here. I had successfully achieve what I want.

Solution: Right Click F2 -> Format cells -> Custom -> Type "ABC "@

Upvotes: 1

Related Questions