User click cell, User input box shows up, User input Numerical Value, Output formula

Hi, I need help with a macro that shows a user input box when user clicks on certain cells. From there, user must input a numerical value. Then the output would be a formula based on another sheet in the workbook. Thanks!

1. When user clicks on any red cell (conditional formatted), user input box pops up

There is no conditional formatting on this sheet. I based the code on the display color of the cells in your sample. A more reliable method would be to duplicate the logic of the conditional formatting, if you are indeed going to use it.

*=B3*Sheet2!B2

There is no Sheet2 in this file. I will use Min instead.

Please consider rewarding genius by adding to my reputation by clicking on the star icon addreputationiconsmall.jpg below my name.