TextBox to display date or "NA"

[AndyEd]

I have a number of TextBoxes that either display a Date, remain blank, or display "NA" if a date is not required.

They are three distinct options - 1) Date required and present; 2) Date required and missing (Blank); 3) Date not required ("NA")

I've formatted the TextBox to highlight it if it is blank (requires an entry).

The issue I have is that I'm using Format(CDate(TextBox),"dd/mm/yy") to display the date and of course it is finding a error as soon as it encounters an "NA". If I don't format the code to display a date, it is displaying the numerical code instead. I've tried various "if" functions in the "Change" sub for the TextBox, but nothing seems to have the desired effect.

I'm not sure where I'm going wrong.

 

[AndyEd]

It doesn't work I'm afraid.

 

[Akuini]

It doesn't work I'm afraid.

Well, if you can share a sample workbook I might be able to help out a bit more.

 

[AndyEd]

I'm not sure how to attach a workbook to this thread?

 

[Akuini]

I'm not sure how to attach a workbook to this thread?

You can't, but you can upload a sample workbook (without sensitive data) to a sharing site like dropbox.com or google drive.
And then share the link here.

 

[AndyEd]

Here's the link

Test - Copy.xlsm

 

[AndyEd]

The issue was the use of CDATE. When using Format it works fine....Doh!

 

[Akuini]

Ok, glad you figured it out.

 

[AndyEd]

Hey, thanks for taking the time to help though. Appreciated.