MyTimeCols problem

  • Thread starter Thread starter drum118
  • Start date Start date
D

drum118

Can someone tell me how to get around the problem of changing the time
in the cols ranges MyTimeCols using Private Sub Worksheet_Change(ByVal
Target As Excel.Range)
Dim TimeStr As String for quick enter?

I have a fair number of workbooks saved using quick enter time and every

time I try changing a time in one of these books I get 0:00 instead of
the number 1234 = 12:34 enter.

All cols still have the name (MyTimeCols) and is time formatted as 1:30
for 24 hr
time. The code is in the book.

If I manually change the number, it will not subtract or be subtracted
in another book.

Thanks
 
If I put the cursors on the cell above the cell that I just type in 1619
(that is supposed to display 16:19) that ends up displaying 0:00, it show
3:39:00 PM up in the formula bar at the top, while the cell display 15:39.
The cell below is 19:39. The cell I just change the time in display
6/6/1904 12:00:00 AM.

I even try renaming the cell to MyTimeCols1 with no luck. Right click >
format cell > time >13:00 and enter with no luck.
Cell above = 15:39 > 15:39
Cell change = 0:00 > 16:19
Cell below = 19:39 > 19:39

I know if I change the number in the formula bar, it will not subtract or be
subtracted in another workbook.
 
It sounds like your macro isn't firing.

If you type 1619 in a test worksheet and format that as mm/dd/yyyy, you'll get
date (June 6, 1904).

You might want to set a break point in your code and step through it to see
where it broke.
 
Dave said:
It sounds like your macro isn't firing.

If you type 1619 in a test worksheet and format that as mm/dd/yyyy, you'll get
date (June 6, 1904).

You might want to set a break point in your code and step through it to see
where it broke.
Click to expand...

It works fine until the book is save.

Code is cut and pasted off the web site.

The range name is the only thing I change.

Yes I get 6/6/1904 (june 4, 1904) in the save book.
 
Back
Top