Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need to move cursor to specific fields | Excel Worksheet Functions | |||
Not allowing to continu unless a specific cell has specific answer | Excel Discussion (Misc queries) | |||
In Excel, how do i automatically re-direct the cursor to a new spr | Excel Worksheet Functions | |||
Link from a specific Cell in Excel to a specific para. in Word | Excel Worksheet Functions | |||
Using Indirect en direct cell references | Excel Discussion (Misc queries) |