View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default 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