Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pointers??
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 -- OzziJC ------------------------------------------------------------------------ OzziJC's Profile: http://www.excelforum.com/member.php...o&userid=24517 View this thread: http://www.excelforum.com/showthread...hreadid=381130 |
#2
|
|||
|
|||
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 -- gazornenplat ------------------------------------------------------------------------ gazornenplat's Profile: http://www.excelforum.com/member.php...o&userid=24494 View this thread: http://www.excelforum.com/showthread...hreadid=381130 |
#3
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In excel pointers should be availible | Excel Worksheet Functions |