Code to send cursor to predefined cell

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Code to send cursor to predefined cell

FAQ

Thread Tools

Display Modes

11-06-2014, 09:57 AM

whatsup

Windows 7 64bit Code to send cursor to predefined cell

Office 2010 32bit

Competent Performer

Join Date: May 2014

Posts: 137

Hi @all

Use Intersect() to verify if the changed cell in deed is the one which shall trigger a certain Selection. The rest is easy:

Code:

Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Range("K12")) Is Nothing Then
        Range("G11").Select
    End If
 
End Sub

Changing the value in K12 and pressing "Enter" will select G11.

Cheers

Tags

send cursor, vba code

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VBA code to select one word from a text in a cell and place that word in next cell	Shinaj	Excel	2	05-01-2014 01:50 PM
Macro code should find inv no in folder and send attachhed mail.	visha_1984	Outlook	0	01-30-2013 05:08 AM
Displaying cursor position within cell	MiamiTom	Excel	0	11-18-2011 09:02 AM
Code for Changing Cell Backgrounds	leroytrolley	Excel	2	12-05-2008 02:05 AM
code to save / rename / send attachments	unit213	Outlook	1	09-26-2007 08:15 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:11 PM.