Clear/Reset Button for sheets with Form Text Boxes

[Heidi2017]

Hi, All:

I am really in need of some help getting the code right for my spread sheets.

I have multiple sheets. There are form text boxes that are linked with cells on other sheets.

Need to figure out the code to create a reset/clear button for the text box as well as the cell that it is linked to ( Right?????)

Any tips on the code would Help....


Sheet 1 the form text box =EMBED("Forms.TextBox.1","") is linked to Sheet 2 cell B5

My end goal is to convert this excel spread sheet into an iphone app.

Thanks,

Heidi