VBA code to auto-convert date

[7abib0]

Hi,

I am a beginner in Excel and I appreciate your support in helping me with the below.

I need VBA code to auto-convert numbers entered in Cell F6, F7, and F27 to a Date format D-MMM-YY.

Example:
051223 to auto-convert to 5-Dec-23 without the need to run ALT+F8 or anything.

Appreciate to provide me with the full code as I am a beginner in Excel VBA.

Thank you in advance.

 

[rlv01]

Are you sure you want a VBA solution? If the format of your date number is always 6 digits, no spaces where the date format is DDMMYY, you can do it with a formula and skip vba

tmp.xlsm
	A	B	C
1	051223	5-Dec-23
2
3
4
5
Sheet4

Cell Formulas
Range	Formula
B1	B1	=DATE("20" & RIGHT(A1,2),MID(A1,3,2),LEFT(A1,2))

 

[7abib0]

Thank you for your reply.

I want VBA code because I am using it in my daily work and my team needs to change the date frequently. So inserting the date as the number will save much time.

Also, I am using a Clear button which will clear any formula inserted in the same fields.