Check a cell format using Visual Basic?

[coolbreeze858]

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

[tadds]

Use the split function of VB to parse and validate the entry. If the split results in only a count of 1 then no forward slash was entered and you can then raise an error. If you get a count of 2 then index[1] = month and index[2] = year. Now you can compare current date month and year against the parsed entry.