ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   another messagebox/form question (https://www.excelbanter.com/excel-programming/273715-re-another-messagebox-form-question.html)

Bob Phillips[_5_]

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?





All times are GMT +1. The time now is 07:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com