I am designing a document with a lot of repetitive formfields.
I have configured each formfield to call a macro after the user has selected an entry from the list.
What this macro should do is change the list entries in the next formfield depending on what the user selected in the present formfield.
Now I've just discovered that
selection.formfields.item
is meaningless since "item" or "formfields" requires an index in parentheses to work but the index is what I'm trying to find out in the first place!
Is there a way in VBA to return the index value of a formfield which has just been changed?
Something like this event:
Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
provided in excel would be VERY helpful, where the current formfield could be a parameter just like the "Target" above.
Thanks a lot in advance.