Check Box to swap between having a formula in a cell and displaying text

I need some help with a Check Box which swaps between a formula and displaying text within a specific cell.

I want to have a Check Box to show the text "Insert Date" in a cell if unticked and have the formula =today() if ticked.

Any help will be appreciated as my vb skills are limited.

Hello
My VBA skills are a little limited too but maybe something like the following would work?

Please Login or Register  to view this content.

Hope this helps.
DBY

Brilliant, that works. Thanks!!