How do I direct cursor to a specific cell?
 

In Microsoft Excel - Upon completion of entry in cell F4 I want cursor to go
to cell E6; then to H4; then to G6, etc.

How do I direct cursor to a specific cell?
 

You could use a worksheet_change event in the sheet module
if target.address="$F$4" then range("e6").select
etc

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Sandman" wrote in message
...

In Microsoft Excel - Upon completion of entry in cell F4 I want cursor to
go
to cell E6; then to H4; then to G6, etc.

How do I direct cursor to a specific cell?
 

Select the cell you want to enter data into, click FORMAT in the menu and
select FORMAT CELLS. Click the PROTECTION tab in the dialog box and remove
the check from the LOCKED check box.

Click OK to exit.

Once you're back in the worksheet, click TOOLS in the menu and select
PROTECT SHEET. Remove the check mark from SELECT LOCKED CELLS and if you want
to add a password.

Click OK to exit.

Now the only cells that are tabbed to are the ones you unprotected earlier.
--
Kevin Backmann


"Sandman" wrote:


In Microsoft Excel - Upon completion of entry in cell F4 I want cursor to go
to cell E6; then to H4; then to G6, etc.