Drop down option automatically choose based on answer

[haziqten]

Hi,

I would like to ask if there is any way for the drop down answer will be automatically choose based on the candidate answer ?
Kindly refer to the attachment below for the details

[humdingaling]

change D4 to formula

Please Login or Register  to view this content.

not 100% sure what you what for Child Relief Claim by
assume Spouse work = Yes > own
if so then this formula should work

Please Login or Register  to view this content.

[haziqten]

I try to remain the data validation but whenever I choose whether YES or NO, the formula is already gone and only based on drop down option.
If I remove the data validation, it will automatically choose YES without NO option.

[FDibbins]

There is nothing magical about a drop down (Data Validation). It is exactly the same as if you had typed the entry in manually, the only differences being that a DD can save you some typing, help avoid typos and help restrict entry to only a specified "list". Other than that, there is basically no difference. You would refer to it in formulas etc the exact same way as if you were referencing a manually entered cell.

And as you probably already know, you cannot have data entry AND a formula in the same cell.

[kvsrinivasamurthy]

With worksheet event it is possible.
No formula is required. Validation is doe by VBA code of worksheet.

Please Login or Register  to view this content.

Right click on the sheet tab of JOB APPLICATION (TEST).
View code
VB window opens.
Paste the code.
Close the window.

[haziqten]

Thanks a lot kvsrinivasamurthy.

It helps me a lot for this code.

[kvsrinivasamurthy]

Thanks for feed back and reputation.
I corrected the procedure for pasting code in VB window in my previous post.

[kvsrinivasamurthy]

Post deleted.

[haziqten]

Thanks again.
Works like charm.

[kvsrinivasamurthy]

To get Lower case change the values in D5:D8 in Option List sheet.
Changed code

Please Login or Register  to view this content.

[haziqten]

The previous code is which you deleted is what I needed.
Whenever the candidates fill in the application form, no matter he/she type in lower case or upper case, it will automatically change to upper case letter.

Please Login or Register  to view this content.

The above code does the trick.

[kvsrinivasamurthy]

If the problem is solved thanks for feed back.