Help With List Box

  • Hello Mate,


    i need top format list fox columns as time. I have populated data from my excel sheet but cant format as time format.


    this is the code i have used.


    Private Sub UserForm_initialize()
    With Sheets("New Requests")
    lstMyData.List = .Cells(3, 3).CurrentRegion.Value

    Me.Control9.Value = "Welcome to Sched Management " & CStr(ThisWorkbook.Sheets("Login").Range("O8").Value)


    End With
    End Sub


    Now i want to format 3 columns as time value.


    Kindly Help

  • Hi,


    Have you already tested the Format instruction :


    Format(.Cells(3, 3).CurrentRegion.Value, "hh:mm AM/PM")


    Hope this will help

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Like" icon ...just below...in the bottom right corner...:)

  • Hey Carim,


    Really appreciate your help. It doesnt seem to work.


    PFA the file.


    Logon Credentials :-


    User Name :- Sarvesh
    Password :- 700003177



    After login it will directly take you to the list box form. I just need the format of time values and column headers.



    Thanks a ton in advance. Waiting for the response.


    Regards

  • Hello again,


    Thanks for the file ... :smile: It makes everything much easier ...


    You could test following :



    Hope this will help

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Like" icon ...just below...in the bottom right corner...:)

  • Hey Carim,


    Now i have a concern. Now this concept appears good to implement in my business. But what if multiple users have to access the same file, say 20 ppl of my team all together get to make entries. How can we handle that, because the excel wont allow multiple access to one file. Can we link everything to DB or what we can do..


    Regards