date stamp

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steve - 31 Oct 2007 11:23 GMT

Hi all,

Using the code below was expecting it too place the current date into
cell h(irow), but am coming up with a compile error.

Any help please

Private Sub cmdadd_Click()
Dim iRow As Long

With Me
iRow = .ComboBox1.ListIndex + 2
Worksheets("All Deals").Cells(iRow, "e").Value
= .TextBox2.Text
Worksheets("All Deals").Cells(iRow, "h").Value = .Format(Date,
"dd/mmm/yy")
End With
Me.ComboBox1.Value = ""
Me.TextBox1.Value = ""
End sub

Reply to this Message

OssieMac - 31 Oct 2007 11:53 GMT

Hi Steve,

Try removing the dot in front of Format. Format is a function and not an
object related to with Me.

regards,

OssieMac

> Hi all,
>
[quoted text clipped - 16 lines]
> Me.TextBox1.Value = ""
> End sub

Reply to this Message

Steve - 31 Oct 2007 12:52 GMT

> Hi Steve,
>
[quoted text clipped - 27 lines]
>
> - Show quoted text -

Thanks Ossie,

amazing what a simple Dot can do, din't even realise it was there lol

Steve

Reply to this Message

Rate this thread: