Msgbox (disable X button)

[VBAva]

morning all
i think this much be pretty easy but mornings and thinking dont really go together.

i have a message box with yes and no on it, and the user HAS to pick yes or no, how can i desable the little X in the top corner to force then to pick something??
i know with user forms you can use QueryClose and CloseMode but does this work with message boxes??

thank you
Ava

 

[combo]

See FormFun in

http://www.bmsltd.co.uk/Excel/Default.htm,

it is an api extension to form design. Maybe a parameter from there can be passed to MsgBox style. As you pointed, a form can be an alternative solution.

combo

 

[VBAva]

Hhmmmmm interesting....

In a message box, if you have vbYesNo or vbAbortRetryIgnore the X button is automatically disabled (never noticed before)
but for all the other button combinations (
vbOKCancel, vbOKOnly, vbRetryCancel, vbYesNoCancel, vbSystemModal) it is enabled!

So what if you want it enabled for vbYesNo and disabled for vbOkOnly??

Ava