Hii I want event If anyone tries to enter value other than number clear the contents... and msgbox popup "Enter Numbers only"
Hii I want event If anyone tries to enter value other than number clear the contents... and msgbox popup "Enter Numbers only"
Last edited by mangesh.mehendale; 09-10-2015 at 05:51 AM.
Don`t care, take care...
Regards,
Mangesh
Hi !
No needs a code, just use cell validation !
Ohh I skipped this simple thing due to addiction of VBA...
But please can you correct this one coz I want to learn VBA..
![]()
Please Login or Register to view this content.
Last edited by mangesh.mehendale; 09-10-2015 at 06:39 AM.
PHP Code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count = 1 And Not Intersect([I207:I216], Target) Is Nothing Then
If Not IsNumeric(Target.Value) Then
MsgBox "Enter Only Numbers in I207:I216 …", vbExclamation, Space(19) & "Range control :"
Application.EnableEvents = False
Target.ClearContents
Application.EnableEvents = True
End If
End If
End Sub
Do you like it ? So thanks to click on bottom left star icon « Add Reputation » !
Actually event works nice... there is possibility of Copy and paste and validation rules get wipe out... thank you very much.. working nice
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks