Restoring Values of Inputfields

[#1]

Hi,

I have a table I created with an input field column. I want to be able to restore all the input field values to their default value by pressing a button, but I can't find the correct macro code to use. I can manually do this by right clicking on one of the input field cells and then selecting Restore Values-->Restore All Values. FYI, the default numbers are based on values in another table, so I don't want to just set them all to 0....

Thanks,

Sarah

[Gysbert_Wassenaar]

See this discussion: how to reset input field values using macro

[#3]

Thanks! This did exactly what I wanted

[#4]

Thanks! This did exactly what I wanted

[#5]

So this worked, but can you explain what the below part of the answer does?

     dim x(1)

     x(0) = 0 ' element to reset