Does not work... no matter what I do it always shows the seconds in the = cell

Sub Button58_Click()
ActiveCell.Value = Format(Now(), "mm/dd/yyyy hh:mm")
End Sub


"Joel" wrote:

you just need to format the cell

activecell.numberformat = "mm/dd/yy hh:mm"

"Joe Wildman" wrote:

Hello everyone, I created a button, when i click on it, it fills a cell with
the current time, i can edit the time after i click the button if needed, I
did some VB code where as that cell will = to cell C35, well that works but
the problem is it shows the seconds and that does not work. any Ideas?

Button:

Sub ss1()

[D8] = Now

End Sub

Also, I have this code that works fine but I am unable to edit the time when
there is a formula in the cell... =MONTH(NOW()) & "/" & DAY(NOW()) & "/" &
YEAR(NOW()) & " " & HOUR(NOW()) &
":" & MINUTE(NOW())