Clear Values but Retain Formulas

Hello,

I am trying to create a form that will be used multiple times a day. I have criteria drop down list in cells F6:F16, with corresponding scores in G6:G16. G6:G16 have formulas to look up criteria if F6:F16 and result in appropriate score. I need VBA code for a RESET button so that the scores in G6:G16 are cleared but the formula is retained so that the next time form is used, user can just hit the reset button and upon selection of criteria from dropdown list in Col F, Col G is automatically filled.

I have a lot of variations but most of them result in removing values and formulas both.

Formulas in column G refer to data in column F. So all you need to do is clear the data in column F:

Please Login or Register  to view this content.

Artik

Mate you are a legend. No wonder you are a Forum Expert. Thank you so much!