View Single Post
 
Old 04-07-2011, 11:47 AM
Johnny thunder Johnny thunder is offline Windows XP Office 2003
Novice
 
Join Date: Apr 2011
Posts: 10
Johnny thunder is on a distinguished road
Default Macro for moving one cell down from current position

Hello Friends,


I have a macro that is copying the results of one form field to about 15 others and I have entered the macro "On exit" so once the user updates the Drop-Down with his comments "Add" "Delete" I need the macro to say move to the next form field or toggle down.


Any ideas? I usually use something like foundcell.Offset(1, 1) in excel but I am not sure how to get it to work in Word?

Here is my code

Sub LMSI_Office()
Dim StrResult As String, i As Integer
With ActiveDocument
StrResult = .FormFields("LMSI_Office1").Result
For i = 2 To 15
.FormFields("LMSI_Office" & i).Result = StrResult
Next
End With
End Sub
Reply With Quote