Using a CheckBox to launch an Input Box

[MaskZA]

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...

[Winon]

Hello MaskZA,

Welcome to the Forum!

You are more likely to get a much quicker response if you attach as Sample Workbook, instead of a Picture. Forum members frown upon issues where they are required to create a Workbook themselves, taking up their time.

the user enters a rate and this populates to another cell...?

If we knew which Cell, it would have been great.

Rather attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Regards.