View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
IanC IanC is offline
external usenet poster
 
Posts: 49
Default Date Format In Combobox

sI have a Combobox whose RowSource is a list of dates for the current and
last year. When I display the dialog, the Combobox shows the dates as their
values as opposed to January 2007, etc.

Picking up on another thread, I have inserted in the activation code for the
dialog the command:

Me.MonthSelectedBox.Value = Format(Me.MonthSelectedBox, "mmmm yyyy") where
the Combo is called MonthSelectedBox. However, I still get the value.

Thanks in advance for any ideas.

Ian