Hi, I would like to set up a spreadsheet that calculates the payroll for my
company, at the moment I can only do this by manually inputting the values
off the cards, I would like to set up a form so that staff just hit clock in
on their way in. Then as they leave they hit clock out, I have a spreadsheet
set up and understand how to do time calculations, macros, forms and most
formulas in excel, my problems is if I link to a cell with time I don't no
how to keep that time, as when the sheet is refreshed the clocks time is
refreshed, and then clock in time is lost, how do I link to a cell, get the
value from it then not have that value change even when the rest of the page
is refreshed thanks for any help.

Instead of using a formula like =now(), you would hard code the value.

activecell.formula = "=now()"
activecell.Formula = activecell.value

or do it directly

ActiveCell.Value = Now

in the second case, this is the VBA function now which is equivalent to the
Worksheet formula, but here you are putting in a fixed value.

--
Regards,
Tom Ogilvy

"Supachad" wrote in message
...
Hi, I would like to set up a spreadsheet that calculates the payroll for
my
company, at the moment I can only do this by manually inputting the values
off the cards, I would like to set up a form so that staff just hit clock
in
on their way in. Then as they leave they hit clock out, I have a
spreadsheet
set up and understand how to do time calculations, macros, forms and most
formulas in excel, my problems is if I link to a cell with time I don't no
how to keep that time, as when the sheet is refreshed the clock's time is
refreshed, and then clock in time is lost, how do I link to a cell, get
the
value from it then not have that value change even when the rest of the
page
is refreshed thanks for any help.