Macro Reformatting Text Input on InputBox

Hi all,

So I'm rather new to VBA and am currently spending some time learning a bit about it and attempting to apply it to to some workbooks.

I've created a macro which displays a pop up where users enter a date, this date then gets pasted into a cell with feeds reports.

When I run this and type the date in as DD/MM/YY it comes out as MM/DD/YY. I've changed the formatting of the cell and ensures it says DD/MM/YY.

Please Login or Register  to view this content.

Thanks in advance,

Sam

P.S. if you have any great learning resources/recommendations for VBA please share

I checked that but it is already set to English (United Kingdom) at DD/MM/YY.

That's done the trick, thank-you!