Solved

read only column , point to opposite field when selected

Posted on 2014-01-19
1
337 Views
Last Modified: 2014-01-19
Folks

the below successfully makes my column a rea-only and when clicking anyway in column a it defaults back to field b3

how do I for example when clicking in field a4 then place me into column b4 or when in a27 then point me to b27



Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Not Intersect(Selection, Range("A:A")) Is Nothing Then
    Range("B3").Select
    End If
End Sub
0
Comment
Question by:rutgermons
1 Comment
 
LVL 43

Accepted Solution

by:
Saqib Husain, Syed earned 500 total points
ID: 39793025
target.offset(,1).Select
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

713 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question