| {\rtf1\ansi\ansicpg1252\deff0\deflang1044{\fonttbl{\f0\fnil\fcharset0 MS Sans Serif;}} \viewkind4\uc1\pard\f0\fs17 While it's always a good idea to validate user-entered data, doing so is especially important when you use that data later in a VB expression. For instance, suppose your procedure takes a number entered by the user and multiplies it by 5. If the user doesn't enter the number correctly, (9..9 instead of 9.99, for instance) VB will generate an error. \par \par To use regular expressions, set a project reference to the Microsoft VBScript Regular Expressions (5.5) option in Visual Basic's References dialog box. When you do, you'll be free to use the RegExp object. The following code validates numeric entry in a textbox named Text1: \par \par Dim myReg As RegExp \par \par Private Sub Form_Load() \par Set myReg = New RegExp \par myReg.IgnoreCase = True \par myReg.Pattern = "^\\d*.\{1\}\\d*$" \par End Sub \par \par Private Sub Text1_Validate(Cancel As Boolean) \par Cancel = Not myReg.Test(Text1) \par If Cancel Then \par MsgBox "Please enter a number in the format ####.##" & vbNewLine _ \par & "(no commas)" \par End If \par End Sub \par } |
Validate numbers in a textbox with RegExp |
India web developer web development India | India web development company India ecommerce web developer