Macro to move focus after entry in a cell

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Macro to move focus after entry in a cell

06-18-2015, 10:04 AM

NoSparks

Windows 7 64bit Macro to move focus after entry in a cell

Office 2010 64bit

Excel Hobbyist

Join Date: Nov 2013

Location: British Columbia, Canada

Posts: 842

Have a look in the attached file. Right click the sheet tab and select view code.

Quote:

However, when an entry is made in G57 (or M57), the last cell in the range, this rule does not apply – the active cell remains G57 (or M57).

this part will require you to hit enter twice in order to advance the selected cell as per normal.

Attached Files

Phil_H.xls (30.5 KB, 16 views)

Tags

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Restrict Cell Entry	Cardinal2	Excel Programming	1	01-30-2015 08:01 AM
Restricting Cell Entry to "N12345678"	balbas662	Excel	3	11-27-2014 12:46 PM
Trying to update a table cell with a value based on a drop down box entry	mkasem	Word VBA	2	09-29-2013 08:36 PM
Macro - Can I move information from a website and excel to word?	redzan	Word VBA	1	03-13-2013 07:39 AM
Move data from 1 cell to another cell	Catalin.B	Excel	1	06-25-2011 12:51 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:20 PM.