+ Reply to Thread
Results 1 to 7 of 7

Combobox & Time Difference issue

  1. #1
    Valued Forum Contributor
    Join Date
    01-11-2012
    Location
    Riyadh, K.S.A.
    MS-Off Ver
    Windows 11 with Excel 2013 & 2016
    Posts
    900

    Combobox & Time Difference issue

    Hello,

    I am seeking help to dispaly the value from sheet into text box. Here are the details.

    When i select any item from combobox then the fax number should show in textbox2 for that perticular selected item i.e. Provider Fax No.

    If possible i need day and time difference in frame 1 fields i.e. turnaround time frame.

    Sample sheet is attached for your refference.
    Attached Files Attached Files

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Combobox & Time Difference issue

    Hello hecgroups,

    Change you ComboxBox event code to what is below. Delete the old code.
    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Valued Forum Contributor
    Join Date
    01-11-2012
    Location
    Riyadh, K.S.A.
    MS-Off Ver
    Windows 11 with Excel 2013 & 2016
    Posts
    900

    Re: Combobox & Time Difference issue

    Thanks Leith Ross it works.
    I have another issue also Turnaround time

    Textbox8 = Textbox3-Textbox5 (This is to find no. of days)

    Textbox9 = Textbox4-Textbox6 (This is to find no. of days) But i need to find difference between AM to PM & PM to AM.

    Let say i received approval at 04:00 PM on 04/07/2012 and i have replied on 05/07/2012 09:05 AM. I have try it but failed.

    Can you fix this also please.

    Thanks for your help.

  4. #4
    Valued Forum Contributor
    Join Date
    01-11-2012
    Location
    Riyadh, K.S.A.
    MS-Off Ver
    Windows 11 with Excel 2013 & 2016
    Posts
    900

    Re: Combobox & Time Difference issue

    It is working when data sheet is active otherwise it is not working any idea about this issue please.

  5. #5
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Combobox & Time Difference issue

    Hello hecgroups,

    Can you show me a before and after example of your previous post? I am not sure how the data should be formatted in the text boxes.

  6. #6
    Valued Forum Contributor
    Join Date
    01-11-2012
    Location
    Riyadh, K.S.A.
    MS-Off Ver
    Windows 11 with Excel 2013 & 2016
    Posts
    900

    Re: Combobox & Time Difference issue

    dd/mm/yyyy format but i have issue with PM-AM & AM-PM
    I hope you unnderstand what i mean

  7. #7
    Forum Contributor
    Join Date
    04-03-2011
    Location
    India
    MS-Off Ver
    Excel 2015
    Posts
    122

    Re: Combobox & Time Difference issue

    Hello Leith

    Please help out

+ 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