Need Help with an user form that convert GTM Time to Other selected Time Zone

Dear All,

I got help on an user form that allow me to convert Zulu time to Eastern Time and work perfectly but now I'm recieving data with other time zone so i need to modify my user form. I added a sheet 2 with all the time zone: Abbreviation, Name and The time different with Zulu Time also added a list box to the user form to select the desire time zone conversion.

The problem is that i know how i want it to work but no how to do it :confused:

This is how I want it to work:

1-Enter the date in Zulu Time text Box1
2-Select the desire Time Zone Coversion from the List Box1
3-When press enter on the convert botton it will enter the result in the Text box 2.

I was thinking to do it with formula but I'm not sure how and i have been stock on this for few days :confused:

Any sugestion is highly appreciated and thank you in advance for your time.

I had attached the file so you will be able to see what i have so far.

Respectfully,

Alex

SHG,

Thank you very much for your fast response, but i cannot use your apporach because i don't have an spreadsheet to be listed like that, what i have are two web databases one that store the data with zulu time and another that store the data in the local tame wherever the costumer is, my work is to match those data an use an userform i had created to collect the correct set of data from both datasource and loaded to a reporting spreadsheet.
the reason i want to use the userform is to incorporate it into the userform i had already so i can do the conversion as soon as i enter the date and time for the first datasource.
the user form that i had attached do that but just for the Easter Time zone.
but with your apporach it is posible to add that formula to an extra columm in my sheet2 and so how make the text box2 to populate the result of the formula in text box2 after you select a time zone from the list box.
this can be an idea but i can't make it to work

Respectfully,

Alex

Any sugestion??, I'm stock here and falling behind.

thanks for your time.

Respectfully,

Alex