Thread: [Solved] ckBox automation
View Single Post
 
Old 08-30-2012, 07:50 AM
coconutt coconutt is offline Windows XP Office 2007
Novice
 
Join Date: May 2012
Posts: 10
coconutt is on a distinguished road
Default ckBox automation

Hello, I have a docx (protected) when a user clicks a ckbox after tabbing out another automatically checks as well. Version two of the document I added more to the docx and made it landscape to accommodate the new column. The issue I am having is when i click on the new column ckbox and tab, the mirrored ckbox doesn't check like the other columns.
Her is what I run on exit:

Code:
Sub MyMacro()
Dim ffld As Word.FormField
Dim rw As Row
 
Set rw = Selection.Rows(1)
rw.Cells(4).Range.FormFields(1).CheckBox.Value = rw.Cells(1).Range.FormFields(1).CheckBox.Value
End Sub
any thoughts on how to get this to work on the other column?
Attached Files
File Type: docx LabOrder.docx (36.8 KB, 13 views)

Last edited by macropod; 08-31-2012 at 05:54 PM. Reason: Added code tags
Reply With Quote