Hello....I have a sample spreadsheet and code attached. I want to enter transactions with a Transaction Date but the problem is the date has to be in MMM-YYYY format without the day portion. I would prefer to have a dropdown to select that is populated but want it formatted as a date so that the data can be sorted in order like Jan-2010, Feb-2010, Mar-2010 instead of as text alphabetically.
On the sample spreadsheet I have used a text box that can be used instead of a drop down but only if I can have code to format it into the correct format upon cell exit. I have this code for the number for the Amount and would like something similar for dates but have not figured out the coding to do that yet.
Can anyone point me in the correct direction for solving this date issue ?
Thanks for your help,
bdsii