Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
text box displaying time?
On a userform, I placed a text box that ties to a cell in
a worksheet that displays a time. However, the text box converts the time to serial code. How do I make the text box display the time as time? SDC |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
text box displaying time?
Hi
Use property Text instead of Value to call the value of the cell. For example in the Initialise event I have: Private Sub UserForm_Initialize() TextBox1.Text = Cells(1, 1)*.Text* End Sub The Text property takes the data as formatted rather than its true value. Tom |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
text box displaying time?
the easiest approach in my opinion is to load the textbox with a string
rather than using a control source. Clear your control source and in the userform initialize event Textbox1.Text = Worksheets(1).Range("A1").Text -- Regards, Tom Ogilvy "scrabtree23" wrote in message ... On a userform, I placed a text box that ties to a cell in a worksheet that displays a time. However, the text box converts the time to serial code. How do I make the text box display the time as time? SDC |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Entering and displaying time | Excel Discussion (Misc queries) | |||
Displaying negative time | Excel Discussion (Misc queries) | |||
Displaying Time in Excel | Excel Discussion (Misc queries) | |||
Displaying time from 00:00 to 0.00 | New Users to Excel | |||
Displaying Unix time as date and time | Excel Discussion (Misc queries) |