Hi,
the problem I am having is shown by the following example.
Cell A1 is formatted "mm:ss.00" and has the value 1:45.26 entered (note that the formula bar displays this as 12:01:45 AM).
I have a userform with a textbox and the following code is entered in the forms initialize event
When the form is opened the value displays as "12:45.00" whereas I was expecting (and wanting) "1:45.26"
Please Login or Register to view this content.
Cheers
Jeff
Try this.
Please Login or Register to view this content.
If posting code please use code tags, see here.
if you aren't including hours you have to use "nn:ss.00" as the format code
Josie
if at first you don't succeed try doing it the way your wife told you to
Hi -
Try
Regards,Please Login or Register to view this content.
Event
You don't need to use Format, the Text property will return the value in the cell as it's formatted.
Thanks for all of your responses.
Norie and Event, both of your suggestions gave a good results. Joseph, your suggestion improved the result but it rounds the value to the nearest second, ie, "1:45.00" instead of "1:45.26"
Cheers
Jeff
Jeff
What I suggested should give you the value exactly as it's formatted on the worksheet.
Did that not happen?
I think Jeff already said it did work-and he marked it solved?
if you don't want to use .Text (which can get slow if you use it a lot) you can use
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks