+ Reply to Thread
Results 1 to 2 of 2

2 questions! Related to combobox and time function.

  1. #1
    Registered User
    Join Date
    05-16-2006
    Posts
    25

    2 questions! Related to combobox and time function.

    hi there!
    I have 2 problems in excel and I count with your help because i don't know the best way to solve them.

    1 - I need to do something like a combobox from where i select one text from others. How do i do this? Is it possible to do it with lists?

    2 - I need a funtion or anything that tells me the precise time hh:mm:ss i write it and doesn't get updated each time change my file like =now() ? How do i best do this? (it's to meant to monitor the lenght of phone calls)


    Hope you can hel me

    Bruno
    Last edited by VBA Noob; 09-28-2007 at 05:22 AM.

  2. #2
    Registered User
    Join Date
    05-16-2006
    Posts
    25
    Ok i already solved problem 1!!

    Problem 2 is resonably done but i would like to make it more acurate.

    The Ctrl+: gives me the correct hh:mm but it doens't give me the seconds even if i chose hh:mm:ss it shows like 11:41:00.

    Is there anything i can change in my EXCEl to give the seconds?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1