trim year and default date

**mtilbury** · 03-24-2015, 06:55 AM

Hi, Im still learning VBA. I'm trying to trim a year built to only show numbers and then default to standard format. If the cell is blank, Also default to a standard format.

The years I receive are

> 1970
1970
1970s
1970's

I need to trim this to 1970.

Once this is done. It needs to default to 31/12/9999 to "31/12/" & Year.Value

If the Cell is blank then then default to 31/12/9999

I tried building it up from scratch below but was getting bigger and messier as i kept trying to get around the debug.

Also I am looking for a Similar code to the below to work for Postcodes.
Looping through and only picking up the first letters e.g. CM15 8KL will be CM and W1 4KH will be W. - Should I set up a new thread for this one?

Please Login or Register  to view this content.

**TMS** · 03-24-2015, 07:41 AM

[QUOTE]Also I am looking for a Similar code to the below to work for Postcodes.
Looping through and only picking up the first letters e.g. CM15 8KL will be CM and W1 4KH will be W. - Should I set up a new thread for this one?/QUOTE]

Google: excel vba code to validate uk post code

If you don't get what you want from one of the links listed in Google, yes.

Regards, TMS