• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pop-Up Messages

L

Liam Birkett

New Member
Afternoon folks

I'm trying to get a pop-up message in cell B2, depending on whether text in cell C2 says "Input Required".

However, I can't seem to find anything that isn't VBA code, and would ideally like to do it using Data Validation

Has anyone come across something similar before?

Many thanks :)
 
Paste this in B2 : =IF(C2="Input Required","Your Text","")

It is checking C2 for the phrase INPUT REQUIRED. When 'found' B2 displays "Your Text". You can edit 'Your Text' to say whatever you need.

I am not aware of causing a pop-up message (message box, user form, etc.) without the use of VBA.

You mentioned Data Validation. Here is a resource : http://database.ittoolbox.com/group.../excel-l/popup-message-without-macros-4344653

https://excelribbon.tips.net/T006177_Adding_Pop-Up_Documentation_to_a_Cell.html
 
Last edited:
You must log in or register to reply here.
Back
Top