Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default automatically jump to top of the next column in a form

I created a three colum form for entering bar code data. How can I
automatically jump to the top of the next column when the last entry is made
in the previous column?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 222
Default automatically jump to top of the next column in a form

Something like this should do the trick:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If ActiveCell.Row = 21 Then
Cells(1, ActiveCell.Column + 1).Select
End If
End Sub

If you attempt to go past row 20 (i.e. row 21) the active cell starts at the
top of the next column.

"Arvin Wilson" wrote:

I created a three colum form for entering bar code data. How can I
automatically jump to the top of the next column when the last entry is made
in the previous column?

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
need to jump cells in column data when finding average, max and mi Andrew Excel Discussion (Misc queries) 1 November 17th 09 10:22 AM
how do I automatically jump to the present date in a roster? awvanheerde Excel Worksheet Functions 3 July 19th 06 03:53 PM
dislike jump bottom of column by double-clicking the bottom of cel Joe Excel Discussion (Misc queries) 1 April 9th 06 09:27 PM
Need formula to jump from one column to the next Amber Excel Worksheet Functions 2 April 8th 06 10:25 PM
opening a form automatically Zygoid[_4_] Excel Programming 8 February 1st 04 10:36 AM


All times are GMT +1. The time now is 08:22 PM.

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

About Us

"It's about Microsoft Excel"