3 digits then move the focus

Posted to microsoft.public.excel.programming

mikewild2000[_7_] mikewild2000[_7_] is offline

external usenet poster

Posts: 1

3 digits then move the focus

I have a little VB code in a "worksheet_change" decalration.

I am trying to add code that will move the focus to C11 once the user
has inputted 3 digits in cell J7

I hope somebody can help.

Thanks.

---
Message posted from http://www.ExcelForum.com/

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
On opening a worksheet move focus to a cell based on date	davcas	Excel Worksheet Functions	1	July 1st 08 02:18 PM
Type set amount of digits in one cell then automatically move to n	mulligbo	Excel Worksheet Functions	2	October 28th 06 12:04 AM
Type 3 digits in one cell then automatically move to next cell.	mulligbo	Excel Discussion (Misc queries)	4	October 27th 06 11:51 PM
The screen should not move to focus on column using when typing	Andeamay	Excel Discussion (Misc queries)	1	November 7th 05 01:46 AM
must press enter 2x to move cell focus	Lynn	Excel Discussion (Misc queries)	0	March 18th 05 06:05 PM

All times are GMT +1. The time now is 12:47 PM.

Menu

About Us