Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
To show a messagebox | Excel Discussion (Misc queries) | |||
MessageBox with tick box | Excel Discussion (Misc queries) | |||
Simple Yes / No messagebox followed by an if then else formula | Excel Discussion (Misc queries) | |||
messagebox in excel 2003 | Excel Discussion (Misc queries) | |||
Printing messagebox | Excel Discussion (Misc queries) |