date button

dementedleach · Newbie Joined: 29 Sep 2010 Posts: 2

I need a button to put the current date into a cell when pressed. I can do it on excel but I'm getting something wrong here. Can anyone help?

RPG · Posted: Wed Sep 29, 2010 2:11 am Post subject:

Hello

Maybe this link can help you.
Read that post and search a method what can working for you.

Romke

dementedleach · Newbie Joined: 29 Sep 2010 Posts: 2

I don't see how that would help. Not even sure what it does.
My original macro,in excel, was:

Private Sub CommandButton1_Click()
Sheets("Sheet2").Range("D4") = Date

I just want that to work in openoffice.

RPG · Posted: Wed Sep 29, 2010 8:56 am Post subject:

Hello

I think you start on the wrong forum.

It is a calc question and not as I did suppose a base question.

I think you can do it with
menu --> Data --> validity

When you see a popup click on the help button in that popup and then study the help file.

Romke

Villeroy · Posted: Wed Sep 29, 2010 2:04 pm Post subject:

Easiest solution with a little setup and 5 key strokes:
Insert>Names>Define...
Name: N (or any other convenient letter)
Refers to: NOW()
[Add]
[OK]

In the cell you type:
=N [F9 key] Enter Enter

Lots of macros to put time stamps into the active cell, named cells, first column, next column:
[Calc,Python,Basic,Base] Several ways to time stamps
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org