User Form - Rounding and Time Formatting text boxes

Good morning,
I have an excel spreadsheet for truck booking - and I have created a User Form for entering and adjusting the data. I have figured out how to get the data to populate from the row I selected but I am struggling with how to adjust my code when loading the data into the UserForm to get the TxtAvTime Text box to be formated as hh:mm as I have in the spreadsheet, and the txtLoadsCalc to have no decimal places.
Hopefully this makes sense.

Oread16=Picture1.jpg

For the time value update the code in your UserForm to this:

Please Login or Register  to view this content.

I'm unclear on the other field because you are already displaying it with no decimal places.

Thank you for your quick response. That was probably not the best screen shot, as you are right it shows only the single digit - I have uploaded another one.

Oread16=Picture2.jpg

Originally Posted by Oread16

I have uploaded another one.

Please put your images inline right in your post rather than requiring people to download a file and then open it to see your screenshot.

To attach an image, first click Go Advanced under your edit box. Then click in the text to set the cursor to where you want the image to appear, then press the image icon and attach your image.

If you want to display it with no decimal places in the userform I would suggest you use integers in the data. You are formatting column O to display a rounded number even though the underlying value is not rounded. You should explicitly round it if that's what you need.

Formula:

Please Login or Register  to view this content.