Time question

[hexOffender]

I have a form that accepts a time entered as "12:50 PM", then saves the workbook. WHen the time is displayed in a textbox it is a fraction "0.534722222222222". The cell is formatted as time, but it still displays as the fraction.:banghead:

[Zack Barresse]

Hi there, welcome to the board!!

Depending on how you are showing the data (you said textbox and cell, two very different things) you may need to use the Format() function. Can you provide more details about what you are trying to do and what you are working with?

[Bob Phillips]

Try loading the textbox using the Text property, not Value



Me.textBox1.Text = Worksheets("Sheet1").Range("A1").Text

[hexOffender]

I added ".Text" and that fixed er right up...

.txtTime.Value = Cells(ActiveCell.Row, 10).Text

[Zack Barresse]

Or, to keep your code more dynamic, I still recommend using the Format() method, so it doesn't matter how your text is displayed on your worksheet, as long as it is still a recognized date (by Excel)...

txtTime.Value = Format(Cells(ActiveCell.Row, 10).Value, "hh:mm AM/PM")

HTH