Hi,
I'm currently using the following to validate entry on a userfrom :
[VBA]If Trim(Me.txtTwo.Value) = "" Then
Me.txtTwo.SetFocus
MsgBox "Please enter the Customers Name!"
Exit Sub
End If[/VBA]
Instead of using this code, is there anyway that I can validate it based on the amount of characters entered? For example, the field must contain at least 3 characters?
Thanks,
Somewhere in the dark and nasty regions where nobody goes, stands an ancient castle.
Deep within this dank and uninviting place lives Berk, overworked servant of The Thing Upstairs.
But thats nothing compared to the horrors that lurk beneath The Trap Door.
Try[VBA]If Len(Trim(Me.txtTwo.Value)) < 3 Then[/VBA]
Me.txtTwo.SetFocus
MsgBox "Please enter the Customers Name!"
Exit Sub
End If
Thank you, that works a treat.
Somewhere in the dark and nasty regions where nobody goes, stands an ancient castle.
Deep within this dank and uninviting place lives Berk, overworked servant of The Thing Upstairs.
But thats nothing compared to the horrors that lurk beneath The Trap Door.
You can also "check as you go"
[VBA]Private Sub txtTwo_BeforeUpdate(ByVal Cancel As MSForms.ReturnBoolean)
If Len(Trim(txtTwo.Value)) < 3 Then
Cancel = True
MsgBox "Please enter the Customers Name!"
txtTwo.Text = ""
End If
End Sub
[/VBA]
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Interesting idea, I'll bear this one in mind for use later. I prefer to let people enter everything and then do the check at the very end as if a popup appears mid-way through the data entry it could cuase other problems if they don't notice and just keep typingOriginally Posted by mdmackillop
Somewhere in the dark and nasty regions where nobody goes, stands an ancient castle.
Deep within this dank and uninviting place lives Berk, overworked servant of The Thing Upstairs.
But thats nothing compared to the horrors that lurk beneath The Trap Door.
No problem. Of course you can't keep typing with a message box on the screen!
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Somewhere in the dark and nasty regions where nobody goes, stands an ancient castle.
Deep within this dank and uninviting place lives Berk, overworked servant of The Thing Upstairs.
But thats nothing compared to the horrors that lurk beneath The Trap Door.
Posting Permissions
Reply With Quote
