Date/Time Entry: From mmddyy hhmm to mm/dd/yy hh:mm [Date Time]

T

Texas Handly

WinXP SP2, Excel XP

I found Chip Peason's Date Time help:
(http://www.cpearson.com/excel/DateTimeEntry.htm)

However, his Worksheet_Charge example VBA Subroutines are either for
Dates or Times.

I need to handle Date + Time in the same field.

I have tried to combine Chip's two example Subroutines into one, but
have not managed to make a single Subroutine that will handle inputs
like "MMDDYY HHMM" [preferred input]

I have not been able to figure out why Chip's Datevalue Sub uses
".Formula" and the TimeValue Sub uses ".Value" when extracting the user
input.

Suggestions?

Texas Handly
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Worksheet_Change: Date Time Input [mmddyy hhmm] to [mm/dd/yy hh:mm] 4
How to enter a date in DD-MM-YYYY format 2
Got dates in dd/mm/yy, Excel refuses to understand this 1
Split date from date time cells dd/mm/yyyy hh:mm. New cell dd/mm/y 3
Force users to enter a range of cell in dd/mm/yy hh:mm format 3
Date dd-mm-yy(EXCEL) manipulation in VB macro 8
HELP! IF Statements Comparing Date/Time Entries (yyyy-mm-dd hh:mm 1
Text Box date format dd/mm/yy not mm/dd/yy 3

Top