Static time that is automatically inserted

**rod50** · 04-17-2013, 03:18 PM

I am trying to do an activity log book where the time is automatically inserted into a cell in column A, that remains static, whenever anything is typed into the corresponding cell in column b.

**stnkynts** · 04-17-2013, 03:47 PM

Try:

Please Login or Register  to view this content.

**rod50** · 04-17-2013, 04:22 PM

Thanks for the reply. I must not be understanding this whole thing. I tried to copy and paste what you supplied, stnkynts, but it didn't seem to do anything. Just to let you know, I have never done anything in VB nor any macros. I am trying to learn. Any ideas?

**stnkynts** · 04-17-2013, 06:05 PM

There is a feature of excel called the visual basic editor. You need to paste this code there, in the specific sheet which you will be doing the work on. In addition, you will need to make sure that your workbook is macro enabled.

**rod50** · 04-17-2013, 06:37 PM

OK. If I understand it I right click on the sheet and choose view code, then paste the code you provided in there. Then I save, go to sheet and it should work.

It doesn't. What am I doing wrong?

I up loaded a macro enabled if that can help.

**stnkynts** · 04-18-2013, 10:13 AM

Well now we are at a conundrum. I opened your attached workbook. Typed something into column B, and column A automatically populated with the time. In other words, works fine for me. Maybe another member around here can try it to confirm that it does or does not work for them.

Only other thing I can think of is that you may have macros disabled in the trust center settings.

**rod50** · 04-18-2013, 10:36 AM

Yes, it does because I have the formula of, =IF(ISTEXT($B10),NOW()) in the cells in column a. Which does put the time of the entry in the way I want it, BUT each time I make a new entry on another row or close and reopen the workbook, the sheet recalculates and puts the, "then current" time in. I need the time to not change. I realize that I could use the shortcut of, Control, Shift, Colon, but I want the time to insert automatically then stay static, not change from the original time. That is, IF, that can be done.

**stnkynts** · 04-18-2013, 06:28 PM

There must be some sort of disconnect here. Regardless of your formula, when you make a change in column B a static time is placed in column A of that same row. If you want a static time entered in a different row, like the rows which already have a formula in it, whenever you make a change in column B that is easy but I would need to know exactly which cells you want the static time in.

Example of what I see:

At 15:22 I typed test into cell B7. Cell A7 automatically reported 15:22:37
At 15:23 I typed test2 into cell B8. Cell A8 automatically reported 15:23:12. Cell A7 still had a value of 15:22:37
At 15:24 I typed test3 into cell B9. Cell A9 automatically reported 15:24:25. Cell A8 and A7 were still unchanged.

**rod50** · 04-18-2013, 06:59 PM

Sorry, stnkynts, I went back and reopened my test bookmacro worksheet. I started checking and noticed a warning that macros were not enabled, I enabled and walah!!! it works, perfectly. Thank you. Now I will have to come up with something else, hope I can remember this for the future. Again, thanks, stnkynts!! and sorry for the confusion, like I said in my intro, I'm learning and from scratch.