Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is there a macro command that would enable a user to jump
to a selected cell? I have a form with 18 cells to fill up. Lets say A1, B2, C3, F4, etc. If the user fills in A1 and press enter or, if the active cell is A1 and the user uses the tab, it will go to B2 and so on. Is this possible? |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Try this macro
Private Sub Worksheet_Change(ByVal Target As Range If Target.Address = "$A$1" Then Range("B6").Selec If Target.Address = "$B$6" Then Range("C1").Selec If Target.Address = "$C$1" Then Range("A1").Selec End Sub |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks! It works when you fill up the cell and press
enter. However, if you press tab, it goes to a "non" selected cell (between selected cells). -----Original Message----- Try this macro: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$A$1" Then Range("B6").Select If Target.Address = "$B$6" Then Range("C1").Select If Target.Address = "$C$1" Then Range("A1").Select End Sub . |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I figured it out. The "non" selected cells were
unprotected. Now it's working perfectly. -----Original Message----- Try this macro: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$A$1" Then Range("B6").Select If Target.Address = "$B$6" Then Range("C1").Select If Target.Address = "$C$1" Then Range("A1").Select End Sub . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Multiple cells or columns are selected instead of selected cell or | Excel Discussion (Misc queries) | |||
Cells are selected but aren't displayed as selected | Excel Discussion (Misc queries) | |||
Cells are selected but aren't displayed as selected | Excel Worksheet Functions | |||
A validated List which link to selected cells according to what is selected on the list | Excel Worksheet Functions | |||
selected cells | Excel Worksheet Functions |