Toggle button issues.

[uniden32]

I'm trying to have a macro run when the workbook is opened, making the user select either "30" or "60" minute timer.

I'd like to then take that entry(either 30 or 60) and put it into a cell so that I can use it later in a script.

I've been looking at the toggle button in the userform, and watched a few videos, but have yet to be able to figure them out.

I'm using Mac 2011, script will run on Excel 2007.


Thanks in advance.

 

[tweedle]

I'm not on mac, but maybe this working sample will assist.

'UserForm General Declarions
Dim DelayInterval As Integer '(30 or 60)
 
Private Sub UserForm_Initialize()
DelayInterval = 30
ToggleButton1.Caption = "Delay: " & CStr(DelayInterval) & " minutes"
End Sub

Private Sub ToggleButton1_Click()
 
If DelayInterval = 30 Then
    DelayInterval = 60
ElseIf DelayInterval = 60 Then
    DelayInterval = 30
End If
ToggleButton1.Caption = "Delay: " & CStr(DelayInterval) & " minutes"
End Sub