need to check whehter value ented is within range in excel using vba code

**ssbhatban** · 10-30-2015, 01:10 AM

Dear Friends

i am new to vba coding & don't have much experience. but i have created a spreadsheet where in i have already used some coding which is working fine

i want to check whether the value etnered in a particular column is whole no & if it is whole no it should be within 0 - 200 only. if not it should give a error message . i had done it using data validation but now i have used it for some other thing & hence i want a vba code for it.

i tried the following code it si not working 7 it als odoesn to check whether it is within 0 - 200.

If Target.Column = 19 And Target.Row >1 And Target.Row <= 1001 And _
Target.Value <> Int(Target.Value) Then
Cells(Target.Row, Target.Column - 1).ClearContents
MsgBox ("not an integer value")
End If

early reply is appreciated

with regards

**vichopalacios** · 11-04-2015, 05:48 PM

@ ssbhatban

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

If Target.Column = 19 And Target.Row > 1 And Target.Row <= 1001 Then
    If Target.Value <> Int(Target.Value) Then
        'With the next line you are deleting the cell to the left of target
        Cells(Target.Row, Target.Column - 1).ClearContents
        MsgBox ("not an integer value")
    End If
    
    If Target.Value < 0 Or Target.Value > 200 Then
        MsgBox ("not in the accepted range from 0 to 200")
    End If
End If
End Sub

need to check whehter value ented is within range in excel using vba code

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

need to check whehter value ented is within range in excel using vba code

Re: need to check whehter value ented is within range in excel using vba code

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Getting error 91 with code to check if range contains data

Code to check ComboBox.Value doesn't already exist in range before attempting to delete

code to check range, if value = N then add another cell to total

Help modifying code to check for text in a range prior to email sheet.

Macro to check range, if false check another range until true, then copy

how can i tell if i have ented the same numbers twice in a column

[SOLVED] how can i tell if i have ented the same numbers twice in a column

[SOLVED] VBA Code to check formulas in a range

Bookmarks

Bookmarks

Posting Permissions