spacepro
Registered User.
- Local time
- Today, 06:38
- Joined
- Jan 13, 2003
- Messages
- 715
Hi All,
I'm very tired and this is probably stating the obvious but I want to assign a value if the time is between 6am and 2pm. What is the syntax in VBA?
Not quite there. Anyone help, gone a bit rusty.
Thanks
Andy
I'm very tired and this is probably stating the obvious but I want to assign a value if the time is between 6am and 2pm. What is the syntax in VBA?
Code:
if time = >#06:00# or <#14:00# Then
'assign value here
end if
Not quite there. Anyone help, gone a bit rusty.
Thanks
Andy