QUOTE(Zhalix @ 14 Aug, 2008 - 08:28 AM)

You can change the buttons to some extent, by specifying one of the setups in the MsgBox function:
CODE
MsgBox "Hey", vbYesNoCancel, "Lalala"
However if you need more than that, you will want to make your own MessageBox. It's pretty simple so don't be afraid to go that route.
To check what the result was, there are a few ways to go about it. If there's only two possible buttons, OR if you only have two possible actions and therefore two of the three buttons do the same thing, then you can use this approach:
CODE
If MsgBox("Are you male?", vbYesNoCancel, "Question") = vbYes Then
'Code
Else
'Code
End If
However if you wanted it to act differently for each of the three buttons, you'd have to switch to another approach. Declare an integer variable to hold the result, and then call the function, like this:
CODE
Dim intResult As Integer
intResult = MsgBox("Are you male?", vbYesNoCancel, "Question")
If intResult = vbYes Then
'Code
ElseIf intResult = vbNo Then
'Code
ElseIf intResult = vbCancel Then
'Code
End If
A list of most, if not all results from the MsgBox:
vbYes
vbNo
vbCancel
vbAbort
vbRetry
vbIgnore
vbOK
I'm sorry I didn't specify exactly what I was trying to do. My message boxes currently already do this---I just am not entirely happy with the options of Yes No...forcing the user to read through my description when I'd really like the button to be more advanced & have a bit of a description in it...
Or have one button be something like "Start Over," and another be "Cancel" (note: my cancel button is a lot more complicated than just unloading the project/stopping the code. I have a routine it needs to run before it can actually stop (deleting the temp stuff it may have copied into the spreadsheet). For the full existing code, you can see my other post.
What I was thinking of doing was something like this userform (I really didn't want to go the userform route...but I want the custom buttons & to make it more visually friendly)
I attached a zip where I included the files that seemed to be generated when I used the File-->Export File thing in the microsoft VB thing when I had the form open. (one's a .frx, the other is a .frm)
This is just to give an idea what the thing's supposed to look like
I want the Yes: I want to cancel button on the userform to goto a certain line of code in my one module--the placeholder TempDelete
In my main module of my existing code (before I created the UserForm Cancelled_Prompt in an attempt to make the prompt a little more user friendly), I added:
CODE
Load Cancelled_Prompt ' to load the userform
Cancelled_Prompt.Show ' to make it visible
I wasn't sure what code I needed to add to either the userform or the main module to get the userform's buttons to do what I want within the code of my main module