Msg Prompt if a row in Column contains unique value

[thekidLegion]

Hey There -

Currently trying to program a type of product questionnaire. I need excel to recognize if a cell in column "F" is populated with a code lets say "384", that excel ask the user "Is the product black?" and change the value in row "G" if the user clicks yes.

So far i've been able to program the latter part, but I'm having trouble writing the code needed for excel to recognize the value in column "F". I need this to apply to ALL cells in Column "F" rather a specific cell (i.e. "F1")

Here's the snippet of the code I'm currently working with.

Please Login or Register  to view this content.

[Winon]

Hello thekidLegion,

Why don't you just use the Code below?;

Please Login or Register  to view this content.

Regards

[thekidLegion]

Hi Winon -

Although the code I've already written works almost-perfectly, you have to click on the cell in column "F" for the message box to prompt.

However, i'd like the message box to prompt auto-magically upon the value being inputted into this cell.

How my worksheet works:
Currently my worksheet looks up criteria and autofills this information in columns B-F based on the product number entered into column A. What I would like to see, is this message box appear after columns B-F have been autofilled, but ONLY if Column F returns the code "384".

[Winon]

Hello thekidLegion,

i'd like the message box to prompt auto-magically upon the value being inputted into this cell.

As I understand your issue, the value in Column F is not entered manually, it appears through a formula if it equals "384", and that unfortunately will not fire any Code to present you with a Message Box to confirm if it is a "Black Product".

Sure, one could Code in such a way that Column G displays "Black Product", if Column F = "384", but what if the "384" in Column F is not a "Black Product"? The system will not be able to dicide when what should apply, besides making it all a "Black Product", hence the caveat of human cofirmation selecting Cells in Column F, to correct the "classification".

The only other rather complicated way, would be to replace your Message Box with a Userform which resembles a Message Box, and try it along the lines as covered here: http://forums.techguy.org/archive-bu...cro-input.html

And that my dear fellow Forum Member, is how far I am able to assist.

Good luck.

Regards

[Winon]

Hi thekidLegion,

I was just thinking, that if you can live with the human interaction, then maybe you would find this Code a bit more user friendly;

Please Login or Register  to view this content.

Regards