首页 | 学习中心 | 注册 登录
返回列表 发帖
Elliotbay

Rank: 2

UID
223186 
帖子
198 
主题
174 
注册时间
2011-7-11 
最后登录
2016-12-5 
1# 跳转到 » 倒序看帖
打印
tT
发表于 2011-10-8 20:30 | 只看该作者

Excel Question re: Time

something, problem, special, create
Let's say in cell A5 I want to enter the time when cell A4 has something in it.

The problem is, if(isblank(A4),"",now()), will automatically recalulate the time everytime I press enter or F9. Is there a way to create a static time? Or do I have to automate a copy-paste special - value command and have it automatically run it when a time is entered?
收藏 分享

ryanlb

Rank: 2

UID
223449 
帖子
323 
主题
8 
注册时间
2011-7-11 
最后登录
2016-4-19 
2#
发表于 2011-10-8 20:36 | 只看该作者
No one? I was really hoping an easy answer existed for this.

I'll just program it in VBA I guess.

TOP

malbec

Rank: 2

UID
223381 
帖子
284 
主题
60 
注册时间
2011-7-11 
最后登录
2014-8-6 
3#
发表于 2011-10-8 20:42 | 只看该作者
Not sure what you're asking for... you don't want the current time, so what time do you want the cell to show?

TOP

segalm

Rank: 2

UID
223365 
帖子
266 
主题
42 
注册时间
2011-7-11 
最后登录
2014-8-7 
4#
发表于 2011-10-8 20:47 | 只看该作者
I want the current time when the data is entered. I want this time to remain and not change.



Edited 2 time(s). Last edit at Monday, July 11, 2011 at 07:16PM by kant.

TOP

Analti_Calte

Rank: 2

UID
222289 
帖子
395 
主题
7 
注册时间
2011-7-2 
最后登录
2016-8-30 
5#
发表于 2011-10-8 20:53 | 只看该作者
This should work:

Right-click the tab > View Code

Then paste this in:

Private Sub Worksheet_Change(ByVal Target As Range)

If Intersect(Target, Range("A4")) Is Nothing Then

Else: Range("A5").Value = Time

End If

End Sub


--------------

Edit: You can replace the word "Time" with either "Now" or "Date" depending on how you want the date/time to read.



Edited 1 time(s). Last edit at Monday, July 11, 2011 at 08:59PM by LukeBBC251.

TOP

返回列表