+ Reply to Thread
Results 1 to 3 of 3

how to avoid null/double click

Hybrid View

var how to avoid null/double click 07-16-2012, 09:14 AM
MickG Re: how to avoid null/double... 07-16-2012, 09:35 AM
var Re: how to avoid null/double... 07-16-2012, 09:55 AM
  1. #1
    Registered User
    Join Date
    12-13-2011
    Location
    farmington MI
    MS-Off Ver
    Excel 2003
    Posts
    81

    Lightbulb how to avoid null/double click

    Hi there, the below event macro creates a line above the cell entry in column A.

    It also creates a line if i double click in cell which i don not want. I just want a line to be created if a number entered in any cell of column A

    Could some one help me..thanks-var

    
    Private Sub Worksheet_Change(ByVal Target As Range)
        If Not Intersect(Range("A1:B400"), Target) Is Nothing Then
            If IsNumeric(Target.Cells(1, 1)) Then
           
                Range("A" & Target.Row & ":J" & Target.Row).Borders(xlEdgeTop).Weight = xlMedium
               
            End If
        End If

  2. #2
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: how to avoid null/double click

    Try this:-
        If Not Intersect(Range("A1:B400"), Target) Is Nothing And Not Target = vbNullString Then

  3. #3
    Registered User
    Join Date
    12-13-2011
    Location
    farmington MI
    MS-Off Ver
    Excel 2003
    Posts
    81

    Re: how to avoid null/double click

    Thanks very much Mike..It works..

    Have a great day--var

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1