Pointers??

O

OzziJC

g'day,
i'm trying to set pointers, so that a cell will automatically be
selected once data has been entered into another cell..

Thanx

JC
 
G

gazornenplat

Not sure what you mean by 'pointers', but you can use the
"Worksheet_Change" event to move the active cell when the worksheet,
er, changes.


Gaz
 
D

Dave O

Here's how to do it:

1. Display the VB editor
2. In the window on the left margin, find VBAProject(Your Filename)
3. Right click the relevant tab name
4. Select View Code
5. On the main window, change the dropdown from (General) to Worksheet
6. Paste in the following code:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$2" Then Range("B10").Select
End Sub

This code causes the cell pointer to move to B10 when the value in A2
in changed. You'll probably need to change those cell addresses-
please note that the $ are required.

Hope this does it for you!
 
Top