Condition Cell

How can I make it so that if a user in enters t or T in a specific cell the cell automatically shows "TRUE" and if they enter f or F the cell shows "FALSE"
I need this condition on cells in range G11:G24

thank you for your time and help.

Hi

It's easier if you restrict the user input to True and False with a dropdown using a list in Data>Validation.

If for some reason you really want to have the user input t or T and automatically change the value of the cell to True, you have to use vba. Use the worksheet Change Event.

HTH
lecxe

I would like to use the change event, but I don't know how write it.

I have this change event I have been using but don't know how to edit it to fit my needs.

Would you know how to change it?

Please Login or Register  to view this content.

Hi again

You can complement VBA Noob's code with Data Validation in the worksheet to ensure that the user is only allowed to enter the letters f and t.

code works, but I am unable to delete the cell contents. How do I fix this??

I think I got It I changed the undo part to this

Please Login or Register  to view this content.

The final product

Please Login or Register  to view this content.

Also, I used the validation msg box option to inform what to write
Thank you both very much for your help