Results 1 to 2 of 2

Thread: MsgBox return value

  1. Oct 22nd, 2000, 05:21 AM #1
    leeckeat
    leeckeat is offline

    Thread Starter
    Member
    Join Date
    Aug 2000
    Location
    Penang, Malaysia
    Posts
    51

    Talking

    i don't know how to get the return value frm msgbox, can u guys help me?

    here is my code:

    sDate1 = InputBox("What is the START date?(dd/mm/yy)")
    sDate2 = InputBox("What is the END date?(dd/mm/yy)")

    MsgBox "Date from" & " " & sDate1 & " to" & " " & sDate2 & ". Correct?", vbOKCancel + vbQuestion, "Weekly / Monthly Report"

    How i know wether the user is click on OK or Cancel??

    thanks.
    Reply With Quote Reply With Quote
  2. Oct 22nd, 2000, 05:30 AM #2
    kedaman
    kedaman is offline
    transcendental analytic kedaman's Avatar
    Join Date
    Mar 2000
    Location
    0x002F2EA8
    Posts
    7,221
    Msgbox is a function too...
    Code:
    ret = MsgBox("Date from" & " " & sDate1 & " to" & " " & sDate2 & ". Correct?", vbOKCancel + vbQuestion, "Weekly / Monthly Report")
Select Case ret
    Case vbYes
    
    Case vbOK
    
    Case vbCancel
    
End Select
    Use
    writing software in C++ is like driving rivets into steel beam with a toothpick.
    writing haskell makes your life easier:
    reverse (p (6*9)) where p x|x==0=""|True=chr (48+z): p y where (y,z)=divMod x 13
    To throw away OOP for low level languages is myopia, to keep OOP is hyperopia. To throw away OOP for a high level language is insight.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width