+ Reply to Thread
Results 1 to 6 of 6

Need Help with an user form that convert GTM Time to Easter Time

  1. #1
    Forum Contributor
    Join Date
    03-14-2013
    Location
    Maryland, USA
    MS-Off Ver
    Excel 365
    Posts
    105

    Smile Need Help with an user form that convert GTM Time to Easter Time

    Dear All,

    I'm back with a new challenge to me. i have create a very simple user form and i want to be able to enter date and time in zulu time zone (GTM) in one text box and it will translate into an Easter Time zone usig the following format MM/DD/YYY : 0000 AM, I now that there are 4 hours difference, I've been looking for the right code with not luck and don't know how to start.
    Any idea or suggestions are very appreciated as always.

    I have attached a sample of the form

    Thank you very much in advance!!!

    Alex
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    12-09-2013
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    171

    Re: Need Help with an user form that convert GTM Time to Easter Time

    Hi,

    You can use the following code in the Form code part or use the file attached.

    Please Login or Register  to view this content.
    This code will add 4 hours to the Zulu time and the target time will be appear once you come out (press tab) from the first text box.

    Otherwise you can add one more button and have the code pasted there in that event.
    Attached Files Attached Files
    Like my answer, then click * below

  3. #3
    Forum Contributor
    Join Date
    03-14-2013
    Location
    Maryland, USA
    MS-Off Ver
    Excel 365
    Posts
    105

    Re: Need Help with an user form that convert GTM Time to Easter Time

    Satabp,

    Thank you for you time helping me with this codes.

    when I try to enter the Zulu time in textbox 1 it give me a type mismatch error.

    What is the advantage of adding a new button? Sorry I'm a beginner.

    Thanks again, I really appreciate your time.

    Alex

  4. #4
    Forum Contributor
    Join Date
    03-14-2013
    Location
    Maryland, USA
    MS-Off Ver
    Excel 365
    Posts
    105

    Re: Need Help with an user form that convert GTM Time to Easter Time

    Satabp,

    It's working perfectly, I was entering the date in the wrong format. Sorry
    but I want the conversion to occur automatically without the need of pressing the tab key or adding another button if it's not possible what should be toe code for the convert button?

    Thank you again for your time I really appreciate your help.

    Alex

  5. #5
    Forum Contributor
    Join Date
    12-09-2013
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    171

    Re: Need Help with an user form that convert GTM Time to Easter Time

    Hi Alex,

    Just copy the given code onto the "Covert" button.

    Thanks,
    Bhanu

  6. #6
    Forum Contributor
    Join Date
    03-14-2013
    Location
    Maryland, USA
    MS-Off Ver
    Excel 365
    Posts
    105

    Re: Need Help with an user form that convert GTM Time to Easter Time

    Bhanu,

    Thank you very much for your time and patient, I really appreciate your help on this.

    It work perfectly!!!!

    Respectfully,


    Alex

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. user form and date & time
    By ed ayers315 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-10-2009, 10:09 AM
  2. User Form To enter Time
    By dollar in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-17-2009, 03:19 AM
  3. Time formate from user form
    By Brento in forum Excel General
    Replies: 0
    Last Post: 08-28-2006, 07:07 PM
  4. Time error in user form
    By bern in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-19-2005, 07:49 PM
  5. Replies: 0
    Last Post: 08-23-2005, 12:22 PM

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