Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I move from cell A 10 to cell B1 with one move or click | Excel Worksheet Functions | |||
Arrow keys move screen instead of moving from cell to cell | Excel Discussion (Misc queries) | |||
Move shape, object, pic to center of new cell based on cell value | Excel Programming | |||
arrow keys move entire sheet instead of cell to cell | Excel Worksheet Functions | |||
Arrow keys move screen instead of moving from cell to cell. | Setting up and Configuration of Excel |