这是语法格式的要求,你只能‘遵守规则’。你想分行写,就照这样: Function tradetime() Dim nowtime As Single nowtime = (Now() - Cells(2, 6)) * 24 If (nowtime <= 9) Or (nowtime >= 15.5) Or ((nowtime > 11.5) And (nowtime < 13)) _ Then tradetime = False Else tradetime = True End If End Function
...
DoEvents ' 加上这个
Next
然后其他时间让该 xls接受响应
(2)DoEvents + Sleep + 时间判断实现延时
用sleep的时候是不是接受响应呀
Dim nowtime As Single
nowtime = (Now() - Cells(2, 6)) * 24
if (nowtime<=9) or (nowtime>=15.5) or ((nowtime>11.5) and( nowtime<13))
then tradetime=false
Else: tradetime = True
End If
End Functionif和then两行总是红色
Function tradetime()
Dim nowtime As Single
nowtime = (Now() - Cells(2, 6)) * 24
if (nowtime<=9) or (nowtime>=15.5) or ((nowtime>11.5) and( nowtime<13)) then
tradetime=false
Else
tradetime = True
End If
End Function
Function tradetime()
Dim nowtime As Single
nowtime = (Now() - Cells(2, 6)) * 24
If (nowtime <= 9) Or (nowtime >= 15.5) Or ((nowtime > 11.5) And (nowtime < 13)) _
Then
tradetime = False
Else
tradetime = True
End If
End Function
在sleep的时候仍然是无法响应
等东西做完,大概周三吧,来给大家结贴,谢谢大家的热心帮助。