I want to ask the question

Do you wish to reopen the whole report or just the offline section of
the report

Is it possible to have a 3 button setup 1, "cancel", 1 saying "open
whole report", and 1 "open offline pay only"

thanks heaps


--
XCESIV
------------------------------------------------------------------------
XCESIV's Profile: http://www.excelforum.com/member.php...o&userid=24271
View this thread: http://www.excelforum.com/showthread...hreadid=546924

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware

Sub Licentiousness()
Dim lngAnswer As Long
lngAnswer = MsgBox("Click Yes to Open Entire Report. " & vbCr & _
"Click No to Open Offline. ", vbYesNoCancel + vbInformation, _
" Moderation in All Things")
If lngAnswer = vbYes Then
'Do something
ElseIf lngAnswer = vbNo Then
'Do something else
Else
'Exit sub ?
End If
End Sub
'------------

"XCESIV"
wrote in message
I want to ask the question
Do you wish to reopen the whole report or just the offline section of
the report
Is it possible to have a 3 button setup 1, "cancel", 1 saying "open
whole report", and 1 "open offline pay only"
thanks heaps
--
XCESIV