My issue is:

I have an Excel sheet with a graph that is automatically updated when the user chooses two dates via drop-down comboboxes. There are around 100 dates in each combobox that the user can choose. Originally, I had these dropdowns set up as validation fields and it worked just fine; however, the down arrows only appeared when the validation cell was selected and I need the arrow to show all of the time so the user is aware that it is a drop-down. So, then I tried to do it via the combobox on the Forms toolbar. This worked great except that I could not format the font. This is a very large spreadsheet and is viewed at 75%, so this would not work either as the font on the drop-downs was much smaller than the rest of the font on the worksheet and hard to read. Lastly, I decided to try the combo-box on the Control Toolbox toolbar. This works great- EXCEPT that after selecting a date, the combobox converst the date from mm/dd/yy format to the numerical date. Is there any way to make it stay in mm/dd/yy format?

Additionally, while I'm fairly comfortable in Excel I have not had much experience with programming- so if the solution DOES involve programming please be very clear with instructions on where to go to insert the code! Thanks in advance for any help I can get- I've been struggling with this for some time now!

Anna