J-Walk Enhanced Data Form

[Michael K]

I am using the J-Walk Enhanced Data Form Add-In. I have
set up a number of fields that usa a combo box one in
particular to select the current date and time. In the
range that activates the combo box for the date I have
used the formulae =now().

The worksheet I have designed collects data on phone
calls, however while the J-Walk Enhanced Data Form is open
all phone calls recoreded show the same time.

Is there a way of updating the time after each record is
entered?

thank you.

 

[Frank Isaacs]

Because =now() is a formula, it is re-evaluated every time you do something
which causes the workbook to be recalculated. That's why they all show the
same time.

My recommendation is to simply use the keyboard shortcut Ctrl-; to enter in
the current date (or Ctrl-: for the time) as a value instead of a formula.
It sounds to me like the combobox is more work than it needs to be.

An alternative is to use the combobox, but don't put the formula in the
range it refers to. Leave it blank, and when the user selects the time, it
should be entered in the range. (I'm unclear how it ISN'T being replaced,
but maybe I'm not understanding exactly how you're doing this.)
--
HTH -

-Frank Isaacs
Dolphin Technology Corp.
http://vbapro.com