reverting the changes made to "Input field"

[raghavsurya]

Hi All,

We are currently using input fields in a straight line table for calculating the valuation of a company. The various components are like Revenue, Profit before Depreciation and Interest, Profit after tax etc. The users need a input field to change the multiple of these component to arrive at value. The below example will explain the situation

Component Amount Multiple Value

Revenue 20000 2 40000

Profit before dep 8000 3 24000

Profit after tax 6000 2.5 15000

The filed "Multiple" is a input field where the user will be able change the mulitple to arrive at a new value. Also, the users need a button to revert the changes made to mulitples to revert back to original multiple of 2, 3, 2.5 for various components.

Can anyone suggest how to handle this situation.

Regards,

Raghav

[Miguel_Angel_Baeyens]

Hello Raghav,

Over your chart inputsum right click and select Restore value.

Hope that helps.

[raghavsurya]

Hi Miguel,

Thanks for your reply. Can you please suggest how we can do using a button. The user need a button to handle this revert activity.

Regards,

Raghav

[Miguel_Angel_Baeyens]

Hello Raghav,

Use the following code

Sub RestoreValues set c = ActiveDocument.GetSheetObject("CH01") c.ResetInputFieldValues 0, 1, 5 '' 0 means all values, 1, means first row, 5 means fifth columnEnd Sub

Hope that helps

[raghavsurya · Accepted solution]

Thanks Miguel.... it works

Regards,

Raghav