Can you get rid of the cancel button from a message box?

[sundance82]

Hi all

I was just wondering can you get rid of a Cancel button from a message box?

Kind regards

Rob

 

[Kyle123]

If by cancel, you mean the cross, then no. Perhaps if you tell us what you are actually trying to do then someone will suggest an alternative

 

[abi_learn_vba]

By defalut Message Box will have 'OK' only. If you are getting Cancel then the code would be like below.

MsgBox "Hello", vbOKCancel

This LINK will give more info about Messge Box.

Regards
-Abi

 

[sundance82]

Thanks Abi thats great and a useful tutorial too. Bit of newbie to programming macros. I realised I actually meant to put input box rather than message box, does the same apply?

Cheers

Rob

 

[vds1]

Rob ,

Better way is to handle Cancel button within VBA. When user clicks on Cancel , variable assigned to the input box will return false.

Test this code,

Sub test()


Testbox = Application.InputBox("Enter Something", Type:=3)


Select Case Trim(Testbox)
    Case False: MsgBox "You Clicked Cancel"
    Case "": MsgBox "No Data Entered"
    Case Else: MsgBox "You Entered :" & Testbox
End Select


End Sub

 

[abi_learn_vba]

Rob,

Inputbox does not work like Message Box. Instead you can go for a UserForm, if you don't want Cancel button.

Regards
-Abi

 

[sundance82]

Rob,

Inputbox does not work like Message Box. Instead you can go for a UserForm, if you don't want Cancel button.

Regards
-Abi

Excellent thanks for your help everyone that's great advice

Cheers

Rob