HOW DO YOU

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cjbarron5 - 23 May 2008 18:48 GMT

can you make the cursor move to the next cell automaticlly after information
is entered and can you make it skip cells that fill with results of formulas

Reply to this Message

Sandy Mann - 23 May 2008 19:05 GMT

> can you make the cursor move to the next cell automaticlly after
> information
> is entered

Tools > Options > Edit and check "Move selection after enter and select the
direction you want.

> is entered and can you make it skip cells that fill with results of
> formulas

Can be done but needs VBA

Signature

HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

sandymann2@mailinator.com
Replace @mailinator.com with @tiscali.co.uk

> can you make the cursor move to the next cell automaticlly after
> information
> is entered and can you make it skip cells that fill with results of
> formulas

Reply to this Message

Gaurav - 23 May 2008 19:47 GMT

If you unlock the cells that you want users to access, protect the sheet and
choose "select unlocked cells only" option, it will automatically skip all
the locked cells.

> can you make the cursor move to the next cell automaticlly after
> information
> is entered and can you make it skip cells that fill with results of
> formulas

Reply to this Message

RagDyer - 23 May 2008 19:56 GMT

This old post describes one way to approach this:

http://tinyurl.com/3kksgy

Signature

HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

> can you make the cursor move to the next cell automaticlly after
> information
> is entered and can you make it skip cells that fill with results of
> formulas

Reply to this Message