Is MsgBox Suitable ?

[stuartgb100]

Hi,
Can I replace the standard ‘Yes’, ‘No’, and ‘Cancel’’ with
for example
‘Insert Rows’, ‘Delete Rows’ and ‘Cancel’ ?
Thanks.

[Paul_Hossler]

No

Best way is to a) rephrase the question to fit the choices or b) make a user form that looks like a MsgBox with your own button text


a) is easiest

b) is not too difficult and can make a project look a little more polished

[stuartgb100]

Paul.

Many thanks. Option a) then, I think.
Regards.

[Paul_Hossler]

18303

That's usually the easiest to build and to maintain





Option Explicit

Sub drv()
Dim Ans As VbMsgBoxResult

Ans = MsgBox("Click ..." & vbCrLf & vbCrLf & _
"[Yes] to Insert Rows," & vbCrLf & _
"[No] to Delete Rows, or" & vbCrLf & _
"[Cancel] to Exit without doing anything", _
vbDefaultButton3 + vbQuestion + vbYesNoCancel, "MsgBox Demo")

Select Case Ans
Case vbYes

Case vbNo

Case vbCancel

End Select
End Sub

[stuartgb100]

Paul,

Thanks again.
That will do nicely.

Regards.