Change formulas text by Input Box

[Panoos64]

Hi all, i would like to change within formula in a range from "C6 : F500" the text OCCUPANCY to TABLE using VBA Input box. Thanks in advance

 

[Fluff]

This is a continuation of this thread. https://www.mrexcel.com/forum/excel-questions/1038815-replace-formulas-file.html#post4986370

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Especially as you already have somebody helping you on that thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).