Move from one cell to another
 

I use Excel but never program in it. However, I use VBA in Microsoft Access
a lot.

Can someone get me started and tell me the syntax to program a spreadsheet
to move the focus from one cell to another once something is entered into the
first cell? Thanks in advance.
--
Don Rountree

Move from one cell to another
 

Here is a program I wrote for somebody this morning that have lots of features.

Sub zip_code()
Dim Cell_Data As String

zipcode_count = 0
For Each MyWorksheet In Workbooks(ThisWorkbook.Name).Worksheets
If StrComp("Summary", MyWorksheet.Name) < 0 Then
RowCount = 1

Do While StrComp(MyWorksheet.Range("C1"). _
Offset(rowOffset:=RowCount - 1, columnOffset:=0), "End") < 0

Cell_Data =
MyWorksheet.Range("C1").Offset(rowOffset:=RowCount - 1, columnOffset:=0).Value
If Len(Cell_Data) = 5 Then

Found_Char = False

For char_count = 1 To 5
character = Mid(Cell_Data, char_count, 1)
If (character < "0") And (character "9") Then
Found_Char = True
Exit For
End If
Next char_count

If Found_Char = False Then

Worksheets("Summary").Range("C1").Offset(rowOffset :=zipcode_count, _
columnOffset:=0) = Cell_Data
zipcode_count = zipcode_count + 1

End If

End If

RowCount = RowCount + 1


Loop
End If
Next MyWorksheet

End Sub


"Don" wrote:

I use Excel but never program in it. However, I use VBA in Microsoft Access
a lot.

Can someone get me started and tell me the syntax to program a spreadsheet
to move the focus from one cell to another once something is entered into the
first cell? Thanks in advance.
--
Don Rountree

Move from one cell to another
 

It should do that automatically if under tools=Options=Edit tab, you
haven't unchecked "move selection after enter"

--
Regards,
Tom Ogilvy


"Don" wrote:

I use Excel but never program in it. However, I use VBA in Microsoft Access
a lot.

Can someone get me started and tell me the syntax to program a spreadsheet
to move the focus from one cell to another once something is entered into the
first cell? Thanks in advance.
--
Don Rountree