Results 1 to 3 of 3

Sub Worksheet_SelectionChange

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-27-2006
    Posts
    310

    Sub Worksheet_SelectionChange

    I have this code:

    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    
        If Target.Address = Range("B1").Address Then _
          Range("B1").Value = 10
          Range("A1").Select
        
      End Sub


    It works fine for place the Value but the problem is that regardless of where I
    click on the sheet A1 get selected.

    I tried an End If after Range("A1").Select but that generates an error.

    Can someone please tell me why the first instruction seems to execute
    only when I click on B1 and the second instruction executes anytime I click the sheet in any cell and how I get the code to run as intended.
    Last edited by VBA Noob; 12-27-2006 at 07:59 AM.

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