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 "Thumbs Up" icon, 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

    Files

  • 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 "Thumbs Up" icon, below, in the bottom right corner:)

  • Very surprised by the fact you are not answering back ... ???

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

  • Hey Mate,


    Sorry for the late response, but was a busy with office work,


    Thanks a lot this worked very well but i need one more help. Will share the file again the new file for the new help.


    Regards
    Sarvesh

  • Hey Mate,


    With the same workbook is it possible to keep data in other file namely sheet :- Login & New Requests in another file so that multiple users can work on the same code at a same time.


    Regards
    Sarvesh

  • Quote

    Thanks a lot this worked very well


    Thanks for your Thanks ...:smile:

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, 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