View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
susan susan is offline
external usenet poster
 
Posts: 10
Default Format date in combobox

Im trying to have a date displayed in the combox as wednesday,
September6. How could I go about doing this
I have tried the format(date, yyyy etc method and it works for
combobox4 but cant use that in combobox3 below.
ie combobox 4 is the start date
comboboxx3 is the end date. I want the enddate selection to begin
with the value enter in cobobox4

Thanks
Mike

Private Sub ComboBox3_DropButtonClick()
Dim leavingdate As Date

leavingdate = ComboBox4.Value
ComboBox3.List = Array(leavingdate, leavingdate + 1, leavingdate + 2)
End Sub