How select selections field in other field with macro?

[warfollowmy_ver]

Hi all!

How select selections field to other field with macro? Analog trigger doing select in field.

= '("' & getFieldSelections([field_name], '"|"', 10000, '$') & '")'

to

field_name_2

[sunny_talwar]

You want to use Macro instead of select in field to select something in a field? I don't have much expertise in Macro, but would like to understand why would you prefer Macro over inbuilt QV functionality?

[warfollowmy_ver]

Because I need to do this about 180 times, and to do so in the trigger for much longer than in the macro as well as the text in the macro is edited instantly, and create each time the action is very long. 😃

[tamilarasu]

You can try,

Sub Test

Set Selections = ActiveDocument.Fields("Field1").GetSelectedValues

ActiveDocument.Fields("Field2").SelectValues Selections

End Sub

[tamilarasu · Accepted solution]

Sorry. By default "GetSelectedValues" syntax stores only 100 values. In your case you need to try like below,

Sub Test

Set Selections = ActiveDocument.Fields("Field1").GetSelectedValues(10000)

ActiveDocument.Fields("Field2").SelectValues Selections

End Sub

[warfollowmy_ver]

Yes! It's work! Thank you!!!