Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 17
Default Go to SELECTED CELLS

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 44
Default Go to SELECTED CELLS

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 13
Default Go to SELECTED CELLS

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 13
Default Go to SELECTED CELLS

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
Search this Thread:

Advanced Search
Display Modes

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
Multiple cells or columns are selected instead of selected cell or Mikey Excel Discussion (Misc queries) 1 April 29th 09 09:48 PM
Cells are selected but aren't displayed as selected Nifty Excel Discussion (Misc queries) 2 September 17th 06 07:22 PM
Cells are selected but aren't displayed as selected Nifty Excel Worksheet Functions 0 September 17th 06 11:34 AM
A validated List which link to selected cells according to what is selected on the list WL Excel Worksheet Functions 1 June 5th 06 08:52 PM
selected cells Juco Excel Worksheet Functions 1 February 13th 05 12:43 PM


All times are GMT +1. The time now is 04:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"