Getting current time into cell as a static value

  • Thread starter Thread starter wadefleming
  • Start date Start date
W

wadefleming

I want to get the current time into a cell either by clicking in the
cell or clicking a pushbutton.

Kind of like using =NOW() but once the value should not change after it
is initially set.

A bit like using Ctrl-Colon but as the spreadsheet will be run on a PDA
it needs to be activated by clicking in the cell or a pushbutton.

Thanks
 
Sub NOWTIME()
ActiveCell.Value = Format(Now(), "h:mm:ss AM/PM")
End Sub

OR a sheet event that would place the static time in a cell when a cell is
double-clicked.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As _
Boolean)
ActiveCell.Value = Format(Now(), "h:mm:ss AM/PM")
End Sub


Gord Dibben Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to run excel vba code when cell value changes from empty to entered value. 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
how to move to another cell to input values from a textbox 1
how to input data into textboxes and make it appear on excel cells 6
combining row values into one cell while filter is active 6
Group List by Values in Column A and combine related row values inColumn B into 1 Cell 7
Splitting up text in a cell 3
Insert random number only if cell empty 1

Back
Top