Changing / dynamic promppt box within Macro

Hi All,


Cell C4 = Question
Cell D4 = Validation field (Yes or No)
Cell E 4 = Details depending on D4

If D4 = "NO", E4 = "NO REQUIREMENT"
IF D4= "YES", run macro and input information in the prompt box. E4 will then equal any information in the prompt box.

What I want to do is everytime the prompt box runs I want it to equal the question in C4, but only if the answer to D4 = "YES".

Below is the macro code I used. Any help would be greatly appreciated!

Please Login or Register  to view this content.

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature below this post.

jbench18,

Welcome to the forum!
Attached is an example workbook based on the criteria you described. It uses a worksheet_change event to generate the inputbox whenever "Yes" is selected from column D. The code is located in the Sheet1 code module.

Please Login or Register  to view this content.