Cancel Button on Msgbox / Inputbox

[RoyinUK2000]

Is there a way to stop the cancel button showing on Msg and Input boxes.

Thx
Roy

 

[Dave Hawley]

Hi Roy

Try
MsgBox "Hello", vbOKOnly

You will find out all the info you need and more by reading the help in Excel on the MsgBox Function.

 

[RoyinUK2000]

Will try that for my Msg boxes but does it work the same for inputboxes??????
Not sure that it does....do you know how to do this on an inputbox

Roy

 

[Dave Hawley]

Hi Roy

While you cannot omit tye Cancel Button from an InputBox a (default) InputBox will return empty text ("") when the Cancel Button is clicked, so you could just use:

Dim strReply As String

ShowIt:
strReply = InputBox("Type any Text", "PREVENT CANCEL")
If strReply = "" Then GoTo ShowIt

MsgBox strReply

This will prevent the Cancel button from working.