Inputbox in Excel 2000

[Lorraine]

How do you suppress (or can you suppress or hide)
the "Cancel" button when creating an inputbox in Excel?
For example, if I create an inputbox, it shows the user
either an "OK" or "Cancel" function - I don't want the
user to pick the "Cancel" feature, because it scrambles
the code. Either they pick the default that shows by
clicking "OK" or they enter a new name for their choice
and click "OK" - can you 'grey out' the "Cancel" button or
suppress it so the user doesn't have that choice? Help!

 

[Dick Kusleika]

Lorraine

I don't think you can change the standard InputBox. You can create your own
userform that looks like the InputBox and have full control over how it
looks. Or you can use code like this to make sure they click OK

Do
x = InputBox("Enter something")
Loop Until Len(x) > 0