Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

VB and excel columns

  Asked By: Rose    Date: Jan 13    Category: MS Office    Views: 818
  

I have the following code, which validates the lenght of the J11 cell:

If Target.Address = "$J$11" Then

Application.EnableEvents = False

With Target

If Len(Range("J11").Value) > 10 Then

MsgBox ("Warning: String is too large.")

End If

End With

Application.EnableEvents = True

End If



What I want to do is to expand this validation to all the cells in
the J column. How can I do this?

Share: 

 

No Answers Found. Be the First, To Post Answer.

 
Didn't find what you were looking for? Find more on VB and excel columns Or get search suggestion and latest updates.




Tagged: