+ Reply to Thread
Results 1 to 2 of 2

Displaying multiple values in a message box

  1. #1
    Registered User
    Join Date
    05-19-2005
    Posts
    7

    Displaying multiple values in a message box

    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

  2. #2
    Dave Peterson
    Guest

    Re: Displaying multiple values in a message box

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1