Visual Basic Editor - Time and Date Entry Continued
Post what you have so far, we are not all familiar with the previous posts.
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Tammy" wrote in message
...
Thanks to everyone earlier who responded to my Time and Date Entry
question.
I'm trying to get these two strings of code to work together in the
Worksheet
Change area, but I'm not understanding why they won't.
I'm trying to enter a date in column A (A1:A10000) and times in columns B
(B1:B1000) and P (P1:P10000). Once the entry is complete, we'll be
running a
calculation of time in the ER department.
I've received the separate codes for date and time entry without hyphens,
slashes, and colons, but I am not able to put them together in the same
worksheet change area... I'm assuming that I'm doing something wrong for
them not to work together, but I don't know how to fix it since this is my
FIRST time working with Visual Basic. I can get the date to work on one
worksheet, and the time to work on another worksheet, but I can't get them
to
work correctly in the same worksheet. Any help would be greatly
appreciated.
Thanks in advance!
|