Hi All,
I have an inputbox in my code. By default the inputbox is giving the options "OK" and "Cancel". Is there a way where I can have only "OK" option in my inputbox.
Thanks
Manju
Hi All,
I have an inputbox in my code. By default the inputbox is giving the options "OK" and "Cancel". Is there a way where I can have only "OK" option in my inputbox.
Thanks
Manju
Re: Inputbox options
No. You would need to create a UserForm. Whgy don't you want a Cancel Button?
Re: Inputbox options
Thanks for the reply Dave.
I want to remove the "Cancel" option because, when the user clicks "Cancel" it returns a false. This is giving me runtime error in the code.
I have attached the file which has the code
Re: Inputbox options
Use code like below
strRW = Application.InputBox("Special Character is: " & vbCr & vbCr & strSC & vbCr & vbCr & "Please enter correct Character", "Special Character")
If strRW = "False" Then Exit Sub
See also: Collect User Data/Input via an InputBox
Don’t have an account yet? Register yourself now and be a part of our community!