Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello community!
Please help find solution of the following problems:
The application uses a field of type Input FIeld.
The application logic needs to select some of these field values and assign a new value.
Assigning new values InputField should be done in a macro, which is activated by pressing a button.
Access to selected / available field values can be obtained using methods GetSelectedValues or GetPossibleValues. The new value can be assigned InputField calling method SetInputFieldValue.The method requires a parameter offset.
Is there a way to get the Offset value in a macro?
P.S. Sorry for the bad English.
Maybe it is easier to use SetInputFieldCell to write inputvalues into (hidden) tablebox or chart.
set table = ActiveDocument.GetSheetObject("TB01")
for RowIter = 1 to table.GetRowCount-1
'write new value into each row, second column
table.SetInputFieldCell RowIter-1, 1, "new value"
next
Maybe it is easier to use SetInputFieldCell to write inputvalues into (hidden) tablebox or chart.
set table = ActiveDocument.GetSheetObject("TB01")
for RowIter = 1 to table.GetRowCount-1
'write new value into each row, second column
table.SetInputFieldCell RowIter-1, 1, "new value"
next
Thank you! Your answer helped me a lot.