Remove Cancel button - Input boxes

[johnske]

Does anyone know of a way to remove the cancel button from input boxes? (or at the very least - disable it)

[Jacob Hilderbrand]

Just make a UserForm and design it the way you want.

You can check if Cancel was pressed though.


Answer = InputBox(...
If Answer = vbCancel Then

[Zack Barresse]

Don't think so. You could disable the response from it by checking the response, if assigned to a variable. Or you could create a userform.

[johnske]

Just make a UserForm and design it the way you want.

Yeah, I was hoping to get away from doing that. Thought there mighta been something easier...Oh well :dunno

[Zack Barresse]

If you don't mind it there, can't you just test for the response of the native InputBox then?

[johnske]

If you don't mind it there, can't you just test for the response of the native InputBox then?

I was hoping to make it so that cancel wasn't even an option :devil: