Multiple choice drop down VBA affecting date formatting? HELP!

Hello,

Please help: I believe a VBA I'm using in order to be able to select multiple options in a drop down list is making my dates format as MM/DD/YYYY rather than DD/MM/YYYY - which is messing up a tracking chart I have going on.

The VBA I'm using is below: Ideally I only need the multiple choices to be for column V & W (22 and 23), and work for a protected work sheet how ever both of these have currently proved impossible for my limited knowledge on this subject.

Any help would be greatly appreciated.

Please Login or Register  to view this content.