Look at the linked cell property--or code behind that combobox.

And if you put a break point at the top of your code, then click the Snd button,
you can step through the code and check what's happening at each step.

Peter wrote:

On Sat, 07 May 2005 06:55:04 -0500, Dave Peterson
wrote:

Option Explicit
Private Sub CommandButton_Snd_Click()

Dim wb As Workbook
Dim Fpath As String
Fpath = "Y:\Callout rotas\"
Application.ScreenUpdating = False
With Sheets("dates")
.Rows(1).Delete
end with

worksheet("Rotas").Copy

Set wb = ActiveWorkbook
With wb
.SaveAs Fpath _
& Format(.Worksheets(1).Range("c2"), "dd-mmm-yy") & ".xls"
'.SendMail
.Close False
End With
Application.ScreenUpdating = True

End Sub

I don't see anything that would change the date to a different cell.

Hi Dave,

I've done a little more checking - when Iselect the date from the
combo box it's at this point that the date is copied to the cell C2 in
the dates worksheet, not as I thought, when I hit the send button on
the form.

I wonder if there is something in the Combo Box properties - I've had
a lokk and there is nothing obvious that would cause this.

Still can't get the row to delete - it's still only the content of A1
that is cleared.
--
Cheers

Peter

--

Dave Peterson