Run code with MsgBox Response

I found one instance where code was run within the response to a msgbox.
I tired to run some simple code within the response from a message box,
for example between IF Response = vbYes and Exit Sub. This may not be able to be
done

Please Login or Register  to view this content.

Thanks to anyone who may shed some light on this issue, hopefully simple????
Thanks in Advance!
Sgt Rock (Dallas)

Assuming you want to color cell A1:

Please Login or Register  to view this content.

Most courteous of you "stnkynts" thanks...let me copy and study and see if I can get this to work....
Thank you again, will be back in a short....
Sgt Rock (Mort in Dallas)

I actually used the vbNo route for that is where the color problem is coming in.
In words, if any of the cells in Range F27:H27 have a value > 100 use Interior.ColorIndex = 6 (yellow)
This is a routine within a larger sub.
Here's the revised code, but when 104 was entered into cell F27 (auto calculated) the interior color did not change to yellow??
Not sure what I am doing wrong - hopefully easy to spot in the code?

NOTE: ALL THE MESSAGE BOXES POP-UP AND WORK PERFECTLY!!

Note that I am looping through the cells for there may be a number in each, and am checking if it > 100 or not.
Thanks a bunch!!!
Sgt Rock (Mort in Dallas)

Please Login or Register  to view this content.

Originally Posted by Sgt Rock

I actually used the vbNo route for that is where the color problem is coming in.
In words, if any of the cells in Range F27:H27 have a value > 100 use Interior.ColorIndex = 6 (yellow)
This is a routine within a larger sub.
Here's the revised code, but when 104 was entered into cell F27 (auto calculated) the interior color did not change to yellow??
Not sure what I am doing wrong - hopefully easy to spot in the code?

NOTE: ALL THE MESSAGE BOXES POP-UP AND WORK PERFECTLY!!

Note that I am looping through the cells for there may be a number in each, and am checking if it > 100 or not.
Thanks a bunch!!!
Sgt Rock (Mort in Dallas)

Please Login or Register  to view this content.

Not sure what's the issue with you, that code is working perfectly fine for me.

May I say lucky you....
Simplistically, the message appears that says "The PBT 100 pound threshold...." - I click OK - at that point I enter a letter (m, p, or o) into column which in turn, will place a number at the bottom of another column.
If the number is > 100 the background color should be yellow.
Conceptually, what I am trying to accomplish is this - if the answer to a statement, i.e., message box is vbNo, then display a message (the PBT message above), after which I click OK, then code will run (that code is to color the cell interior if the value is > 100).

I'm wondering what the flow of code is after one presses OK to a message box????

You assistance is graciously appreciated....

Sgt Rock (Mort in Dallas)

I "think" I know the issue - I'm running the colorindex code BEFORE there is an entry in the range F27:H27
Just did a test, another message box, "got here" and the flow does in fact pass on to the code:

Please Login or Register  to view this content.

I have to figure out how to run the code AFTER there is an entry in the range F27:H27.
Thanks for our suggestion - most appreciated...
Sgt Rock (Mort in Dallas)

If you want to run the code after there is an entry in range F27:H27 you will need to utilize the worksheet_change event. Something like this:

Please Login or Register  to view this content.