No cancel on input
Input boxes always have cancel buttons. What you want to do is to catch when
the user has selected Cancel. take a look at the value returned by the input
box when cancel was selected and create some code to deal with it.
--
HTH...
Jim Thomlinson
"Luis A. Vázquez" wrote:
How can i make an inputbox...popup, that does not have a cancel
button?
Is this possible? This is the code i have that i would like to
elimitate the cancel button.
Sub Auto_Open()
name = Range("A2")
A2 = name
If A2 = "" Then
A2 = InputBox("Entra tu Nombre ", "Nombre .")
Else
End If
Worksheets("Sheet1").Range("A2").Activate
ActiveCell = A2
End Sub
|