Message Box

[abac]

Hi everyone,

I'm looking to have a message box pops up when user put specific word. I'm using the following formula but it's not seem to be working.

Please Login or Register  to view this content.

Please can someone help

many thanks

[Rick Rothstein]

Please Login or Register  to view this content.

Since your range is fixed, try changing the above line of code to this...

Please Login or Register  to view this content.

[abac]

Thank you for the quick reply.

I'm encountering a problem that the message box is popping up even if there is something else in the cell.

For example in D14 I put 30 minutes - the same message pops up. I only want the message to pop up if anyone put "Over 2.5 Hours"

Please can you advise me on that.

Thank you

[Rick Rothstein]

I assumed you wanted the MessageBox to appear if the words "Over 2.5 Hours" appeared in any one of the cells in the range D13:D69 no matter what values existed in the other cells. Apparently that is not what you wanted... can you explain in more detail what you do want?

[abac]

I want if the word "Over 2.5 HOurs" appeared in either of the cell between the range of D13:D69 then the message box appears

thanks

[abac]

for example

d13 - "Over 2.5 Hours" - Message box appears
d14 - 1 hour - no message box
d15 - 2 hours - no message box
d16 - "Over 2.5 Hours@ - Message box appears

[Rick Rothstein]

I think I may have misunderstood what you wanted. My code was looking at all the cells in the range all at once to see if any of them had that text in it. Are you saying that you want to check each cell individually as the user enters text into them to see if their individual entry contained the text you were looking for?

[Winon]

Hello abac,

I could have a look at it for you, but i have not heard anything from you in this Thread.

No Reputation added, nor a thank you.

Regards

[abac]

Hello abac,

I could have a look at it for you, but i have not heard anything from you in this Thread.

No Reputation added, nor a thank you.

Regards

Hi Winon
I’m so sorry about that and thank you for time and support on the other post. Your help was very much appreciated
Thanks once again pal

[abac]

I think I may have misunderstood what you wanted. My code was looking at all the cells in the range all at once to see if any of them had that text in it. Are you saying that you want to check each cell individually as the user enters text into them to see if their individual entry contained the text you were looking for?

Hi Rick

Yes that’s correct.

Thanks a lot

[Rick Rothstein]

See if this event code does what you want...

Please Login or Register  to view this content.

HOW TO INSTALL Event Code
------------------------------------
If you are new to event code procedures, they are easy to install. To install it, right-click the name tab at the bottom of the worksheet that is to have the functionality to be provided by the event code and select "View Code" from the popup menu that appears. This will open up the code window for that worksheet. Copy/Paste the event code into that code window. That's it... the code will now operate automatically when its particular event procedure is raised by an action you take on the worksheet itself. Note... if you are using XL2007 or above, make sure you save your file as an "Excel Macro-Enabled Workbook (*.xlsm) and answer the "do you want to enable macros" question as "yes" or "OK" (depending on the button label for your version of Excel) the next time you open your workbook.

[abac]

yes it worked - what a star.

Thank you so much - I truly appreciate your support.

[Winon]

Hello abac,

If you are satisfied that any of your Threads had been replied to successfully, then please do mark such Threads as Solved. You may also add to the contributors' Reputation by clicking on the star * "Add Reputation", located to the bottom left of that Post, and follow the prompts.

Regards.