Hi,

I currently have a userform where the user selects a series of time values from a combo box drop down:

Me.cmbStartTime.RowSource = "TimeList"
Me.cmb1stBreakTime.RowSource = "TimeList"
Me.cmbLunchTime.RowSource = "TimeList"
Me.cmb2ndBreakTime.RowSource = "TimeList"
Me.cmbEndTime.RowSource = "TimeList"
Timelist refers to the names range I have for the times that can be selected.

I then use the following code to display the times correctly in the combo box instead of numerical values:

Private Sub cmbStartTime_Change()
    ' Format the selection
    cmbStartTime = Format(cmbStartTime, "h:nn AM/PM")
End Sub
Private Sub cmb1stBreakTime_Change()
    ' Format the selection
    cmb1stBreakTime = Format(cmb1stBreakTime, "h:nn AM/PM")
End Sub
Private Sub cmbLunchTime_Change()
    ' Format the selection
    cmbLunchTime = Format(cmbLunchTime, "h:nn AM/PM")
End Sub
Private Sub cmb2ndBreakTime_Change()
    ' Format the selection
    cmb2ndBreakTime = Format(cmb2ndBreakTime, "h:nn AM/PM")
End Sub
Private Sub cmbEndTime_Change()
    ' Format the selection
    cmbEndTime = Format(cmbEndTime, "h:nn AM/PM")
End Sub
The problem I am having is that once the values are entered and the cells populated after submission, cells referring to the newly created time cells are not calculating properly. I'm not sure if this a formatting issue or a problem with my formulas.

Thanks!

M