View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_5_] Bob Phillips[_5_] is offline
external usenet poster
 
Posts: 620
Default another messagebox/form question

libby,

On a messagebox it's as simple as

Dim fResult
fResult = MsgBox("Select from these buttons", vbAbortRetryIgnore)
Select Case True
Case fResult = vbAbort: MsgBox "Abort"
Case fResult = vbRetry: MsgBox "Retry"
Case fResult = vbIgno MsgBox "Ignore"
Case Else: MsgBox "Unknown"
End Select

On a form it's a different situation as they do not have pre-assigned
values. For instance, if you create an OK button, you test for it being
pressed by trapping the CommandButton1_Click event (or whatever you rename
the button to).

--

HTH

Bob Phillips

"libby" wrote in message
...
ok is there anyway of retrieving the windows icons such as
the vbinformation etc, to use on your own form?