I have a create, edit, delete program I've done in excel and I need to
pass a start time and end time value back and forth from cells to my
userform. I've tried using military format HHMM and 00\:00. It works
fine passing the time value from the userform to the cell, but not the
other way!! Here's my variable (dim as date):

BeforeEditStartTime = Format(Range("F" & rowindex).Text, "HHMM")

The cell this value is entered in is in custom HHMM format. When I pass
it back to the program it reads (for example) 1200 as 0000 or 12:00:00
AM.

HELP!!