Hi all,

I am wanting to have an input box pop up when a checkbox is marked so that a user can enter a value and that value is then placed into a particular cell.
Here's what it looks like:

Checkbox.jpg

The idea is that the CPM cell picks up either a standard rate or, if the checkbox is checked, an input box pops up, the user enters a rate and this populates to another cell which is then used as the CPM (If checkbox linked cell =TRUE).

Hope that helps clarify what I need...