• 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.

Automatic POP Up message

A

arshad_masud

Member
Hi..


Can any one help me in raising automatic pop up in excel without using VBA. e.g. when any value exceeds certain limit there should be a message "Validity period Expires".


Thanks
 
You can do that in a cell

Eg: =if(D10>100, "Validity period Expires","")

And make the cell Red Bold font
 
What has you defined in the data validation rule.


If the entry is only for number between 1 to 100


Allow = Whole Number

Data = Between

Minimum = 1

Maximum = 100


And then define the Error alert. Everytime the user inputs a number which is not in the limit; the Popup will come on the screen advising the same.


~Vijay
 
arshad,


Still using Data Validation, but you need to use a custom formula, if the cell that you want to impose limits on is actually a formula resultant.

Example:

Lets say we input a number into A2, and A3's formula is:

=A2*2

But we don't want A3 to ever be more than 100. The data validation for A2 then is:

=A3<100


If you formula has more than one precedent cells, you would probably want to setup the validation on each of the cells.
 
Arshad,


As you can already see, everyone is ready to help.


All i think is missing is a good explanation of the real issue... if you can specify the extact requirement; it would make it a lot easier for everyone here to assist.


Looking forward to your next post will max possible details on the issue at hand.


Cheers

~Vijay
 
Arshad

You can add the following code to the worksheet module for the worksheet you are interested in

Change as Address and Value as appropriate

[pre]
Code: 
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$2" And Target > 100 Then MsgBox "Validity period Expires", vbCritical, "Validity period Expires"
'Change Addrerss and value to suit
End Sub
[/pre]
 
Thanks Luke, Vijay & Hui


I really appreciate your efforts. I think i should use Hui's earlier guidance i.e. =if(D10>100, "Validity period Expires","")as it is simple and moreover i dont' know anything about VB.


Thanks Pal
 
You must log in or register to reply here.
Back
Top