LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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?



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
To show a messagebox pol Excel Discussion (Misc queries) 3 July 17th 09 01:05 PM
MessageBox with tick box Sophie Excel Discussion (Misc queries) 3 February 5th 09 02:32 PM
Simple Yes / No messagebox followed by an if then else formula mike_vr Excel Discussion (Misc queries) 2 January 18th 08 01:30 PM
messagebox in excel 2003 Brett17 Excel Discussion (Misc queries) 1 November 28th 06 08:00 AM
Printing messagebox nc Excel Discussion (Misc queries) 1 March 22nd 05 02:49 PM


All times are GMT +1. The time now is 02:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"