I'm new to Visual Basic and writting code for excel.
My first attempt at writting a piece of code is to format a range of cells to display a particular date and time format. dd/mm/yy hh:mm.
My problem is that I have written the code that uses a drop down menu from the main menu in excel and an input box, when I enter a specific date and time into the input box and click ok the date is reversed from the format above to the following mm/dd/yy hh:mm. this is causing severe problems for me.
The cells are all formated using the custom format to the above. I'm very inexperinced at writting the code.
Can someone help my write the code I need.