DST

shaker

Board Regular
Joined
Jul 19, 2002
Messages
88
Hi,
i formated different cells with different tome zones, now under each time zone i added two option buttons, when you click on one it puts the time 1 hour forward and when u click on the other it reverts back to old time. does any one know the formula/code for this?
thnx in advance
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
On 2002-08-04 03:01, shaker wrote:
Hi,
i formated different cells with different tome zones, now under each time zone i added two option buttons, when you click on one it puts the time 1 hour forward and when u click on the other it reverts back to old time. does any one know the formula/code for this?
thnx in advance

Hi Shaker
I'm off now....if you don't get a reply
then send me your workbook and I'll give you examples....plus a GMT calc workout

Bye
 
Upvote 0
Here's one way.

Let's say you want the time in A1 to be either seven hours or six hours ahead of your computer time.

Format A1 as Time and attach these macros to option buttons obtained from the Control Toolbox:-

Private Sub OptionButton1_Click()
[A1].Formula = "=now()+7/24"
End Sub

Private Sub OptionButton2_Click()
[A1].Formula = "=now()+6/24"
End Sub
 
Upvote 0

Forum statistics

Threads
1,226,616
Messages
6,192,042
Members
453,691
Latest member
CT30

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top