Validation with a Spreadsheet Cell : Cell Value « Excel « VBA / Excel / Access / Word

VBA / Excel / Access / Word 1.  Access 2.  Application 3.  Data Type 4.  Data Type Functions 5.  Date Functions 6.  Excel 7.  File Path 8.  Forms 9.  Language Basics 10.  Math Functions 11.  Outlook 12.  PowerPoint 13.  String Functions 14.  Windows API 15.  Word 16.  XML Java Java Tutorial Java Source Code / Java Documentation Java Open Source Jar File Download Java Articles Java Products Java by API C# / C Sharp C# / CSharp Tutorial ASP.Net JavaScript DHTML JavaScript Tutorial JavaScript Reference HTML / CSS HTML CSS Reference C / ANSI-C C Tutorial C++ C++ Tutorial PHP Python SQL Server / T-SQL Oracle PL / SQL Oracle PL/SQL Tutorial PostgreSQL SQL / MySQL MySQL Tutorial VB.Net VB.Net Tutorial Flash / Flex / ActionScript Microsoft Office PowerPoint 2007 Tutorial Microsoft Office Excel 2007 Tutorial Microsoft Office Word 2007 Tutorial

VBA / Excel / Access / Word » Excel » Cell Value   Validation with a Spreadsheet Cell   Private Sub Worksheet_Change(ByVal Target As Range)     Dim cellContents As String     Dim valLength As Integer     cellContents = Trim(Str(Val(Target.Value)))     valLength = Len(cellContents)     If valLength <> 3 Then         MsgBox ("Please enter a 3 digit area code.")         Cells(9, "C").Select     Else         Cells(9, "C").Value = cellContents         Cells(9, "D").Select     End If End Sub   Related examples in the same category 1.  Define a string type variable and set to Cell(1,D) 2.  StrConv("ALL LOWERCASE ", vbLowerCase) 3.  Format("ALL LOWERCASE ", "<") 4.  Checks values in a range 10 rows by 5 columns 5.  Checks values in a range 10 rows by 5 columns with nested for loop 6.  Place the value (result) of a formula into a cell rather than the formula. 7.  Assing value in Cells to array, do the bubble sort and assign them back 8.  transposes the values of a group of cells in a worksheet 9.  Determining a cell's data type 10.  Calculate cell

w__ww__.__j__a_v_a__2s__._co__m___ | Contact Us

Copyright 2003 - 08 Demo Source and Support. All rights reserved.

All other trademarks are property of their respective owners.