ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,199
- Office Version
- 2007
- Platform
- Windows
Hi,
Ive been trying to apply vbInformation to my InputBox but without joy as i would then just see the InputBox title in the field where i was to enter a value.
The code for the InputBox is shown below.
Is it possible to even do this ?
Ive been trying to apply vbInformation to my InputBox but without joy as i would then just see the InputBox title in the field where i was to enter a value.
The code for the InputBox is shown below.
Is it possible to even do this ?
Rich (BB code):
z = CInt(Application.InputBox("WHICH ROW SHOULD DATA BE INSERTED ?", "NEW CUSTOMER ROW NUMBER MESSAGE", Type:=1))
For i = 1 To 11
With Me.Controls("TextBox" & i)
If .Text = "" Then
MsgBox "ALL FIELDS MUST BE COMPLETED", 48, "GRASS NEW CUSTOMER FORM"
.SetFocus
Exit Sub
End If
End With
Next i