Change the button text in VBA for a MsgBox?

Question

I am trying to find a way to change the button text on a msgbox so it says something different on the button
Eg: - instead of the button showing "Ok" whth vbOkOnly, I want it to say something else like "Go"

Answer 1

You can make your own msgbox by creating your own FORM.

Answer 2

#SingleInstance
SetTimer, ChangeButtonNames, 50
MsgBox, 4, Add or Delete, Choose a button:
IfMsgBox, YES
MsgBox, You chose Add.
else
MsgBox, You chose Delete.
return

ChangeButtonNames:
IfWinNotExist, Add or Delete
return ; Keep waiting.
SetTimer, ChangeButtonNames, off
WinActivate
ControlSetText, &Yes, &Add
ControlSetText, &No, &Delete
return

Answer 3

I think you can modify the caption of your own forum. Msgbox is an built in function so it can only have specific value

Answer 4

hi, this can fix the first situation: Sub CommandButton1_Click() ActiveCell.value = software.WorksheetFunction. suited(ActiveCell.value) end Sub As for the 2d situation i do not have time in the present day to look at it yet i'd do so later. thanks.