I have vb code/form which will go into a data set, find an event based on a user input, graph 16 columns of data on individual graphs based on the address of the event (example...$b$6300). The user inputs amount of time prior to event at b6300 and the amount of time after the event to plot. All of this works fine.
The problem arrises when I try to place a text box on each graph containing the time of the actual event. The time is located in the column next to the event (a6300). I currently assign the the time to a variable "EVENTTIME". When the time goes in the box, its is in serial format (0-23:59:59 = 0-.99999999).
Question = How do I get the format in the text box (automatically) to be in hh:mm:ss.000 format?
The problem arrises when I try to place a text box on each graph containing the time of the actual event. The time is located in the column next to the event (a6300). I currently assign the the time to a variable "EVENTTIME". When the time goes in the box, its is in serial format (0-23:59:59 = 0-.99999999).
Question = How do I get the format in the text box (automatically) to be in hh:mm:ss.000 format?