Problem entering Time Data

[K m]

I would like to enter data in certain cells and have them converted to time format.

For example, if I enter 730 in cell I17, I want it converted to 7:30.

I tried to follow an example in CPearson.com but for some reason, it didn't work.

Please Login or Register  to view this content.

BTW: The range, I want this macro to work on is: Range I17:I20, B30:C32 and L39:41.
I tried changing the A1:A10 above but it didn't work

Can someone help?

I have included an example file with the cells in question marked in yellow

No sure what I am doing wrong

Thanks

[JasperD]

Try this (worked for me )
And please remember to put your code on the worksheet you're using instead of in a module.

Please Login or Register  to view this content.

Please click the * below if this helps

[scott.s.fower]

the original code works too, but JasperD is right, you need to have it in the sheet code, not a module, right click on the sheet tab and click view code, then paste it there

i did it for you, so you can see where it goes, you will see that there are no modules, double click the actual sheet when you are in the vba editor
test.xlsm

[K m]

Pardon me. I am not well versed in Visual Basic. I understand how to add VBA code to an individual worksheets and know how to make a Visual Basic module but don't understand the difference between worksheet macros and module macros? How did you know this was a worksheet macro?

I have a need to do this to multiple sheets. Would I have to duplicate this code for each worksheet? Could I make a module that is useable for multiple worksheets?

[scott.s.fower]

Worksheet code has a name worksheet_something, where as module code is any name, you can just put one line like call module as the code and it will run the module. Workssheet code is triggered by an event on that sheet,ie selection, change etc