Is there a way to

startcheck = MsgBox(startvalue, vbOKOnly, "The cycles will be processed

with the following start time:")
endcheck = MsgBox(endvalue, vbokkonly, "The cycles will be
processed until the following end time:")
DurationCheck = MsgBox(duration, vbYesNo, "Would you like to
continue processing the cycles with the following duration in hours?")
Select Case DurationCheck
Case vbYes
'do nothing
Case vbNo
'exit macro
Exit Sub
End Select


--
Dani
------------------------------------------------------------------------
Dani's Profile: http://www.excelforum.com/member.php...o&userid=23542
View this thread: http://www.excelforum.com/showthread...hreadid=499905

Maybe...

Option Explicit
Sub aa()

Dim StartValue As Long
Dim EndValue As Long
Dim StartCheck As Long

StartValue = 12
EndValue = StartValue + 5

StartCheck = MsgBox(Prompt:="Start: " & StartValue & vbLf & _
"Finish: " & EndValue & vbLf & vbLf & _
"Continue?", Buttons:=vbYesNo)

If StartCheck = vbNo Then
Exit Sub
End If

End Sub

Dani wrote:

Is there a way to

startcheck = MsgBox(startvalue, vbOKOnly, "The cycles will be processed

with the following start time:")
endcheck = MsgBox(endvalue, vbokkonly, "The cycles will be
processed until the following end time:")
DurationCheck = MsgBox(duration, vbYesNo, "Would you like to
continue processing the cycles with the following duration in hours?")
Select Case DurationCheck
Case vbYes
'do nothing
Case vbNo
'exit macro
Exit Sub
End Select

--
Dani
------------------------------------------------------------------------
Dani's Profile: http://www.excelforum.com/member.php...o&userid=23542
View this thread: http://www.excelforum.com/showthread...hreadid=499905

--

Dave Peterson