Ok this one complex.

I have a single cell with a cell format of text.
However i want the cell to only take an expiry date of 12/09 for example, also at the same time checking that the expiry date is greater than the current date.
but i need this as vb code, writtern in a IF statement under an ElseIF condition.
I need to have the forward slash in the format as well

hope someone can help thankyou.
thanks for the answer already, but i do have limited knowledge on programming, can someone please simplify an anwser to my question, with some wriiten code thankyou.

e.g:
ElseIf Range(C17:C19).Text = ? or sum thing like this thankyou, must be in an ElseIf