complex Message boxes

[Faction21]

How do I make a message box? not the ones that you find in macros that only allow you to press ok, bu i mean message boxes that can decide what action happens next, with yes & no buttons and such.

Can anyone help me out?

 

[Mile-O]

If MsgBox("The text that goes inside a textbox.", vbYesNo + vbQuestion, "Title of textbox") = vbYes Then
    ' do something
Else
    ' do something else
End If

 

[maxmangion]

do a search for msgbox, there are plenty of threads, discussing message boxes.

 

[Faction21]

How about inside a macro?

Condition:
MsgBox("Confirm changes?",1)=1

Action:
Stop Macro

This displays a Ok, Cancel message ox that is suppoed to stop the macro if the Cancel button is pressed, but it does the opposite for me, it runs the macro either way

 

[GabrielR]

Maybe??

OK, I don't know if this will answer your Question.

If I need a Custom Message box that have buttons outside from the optional VB stuff and the like, what I do is:
Create a form
attach an image a message and the buttons with their appropriate Macros/code,
and set the border as message box.

 

[Mile-O]

How about inside a macro?

Sorry, I'm too elitist for macros.

Are the five lines given above really that hard to understand?

There's many arguments not to use macros...

 

[Faction21]

well, The forms that i make use macros to preform many tedeous tasks, i just need a simple textbox that can be incoperated into a step in a maco.

Where would I use the code posted above? In a module? i dont want to create a form just so i can use a simple text box. But, I will need to have a complex box real soon, but i need to get the simple stuff in place first.