Data Validation Information Alert

**RunHard** · 07-01-2009, 09:34 AM

Hello

Is it possible to have an information alert through data validation when a cell reaches certain values. Cell C5 is populated by results in other cells. When the value in C5 equals 5,15,25 I want the alert to activate. I have tried custom in the data validation menu but can't get it to work.

Thanks

RunHard

**sweep** · 07-01-2009, 09:52 AM

You would need VBA in the worksheet module to pop up a messagebox.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Range("a1").Value Mod 5 = 0 And Range("a1").Value <> 0 Then MsgBox ("Alarm")
End Sub

You could use conditional formatting...

=AND(MOD(A1,5)=0,NOT(ISBLANK(A1)))

**RunHard** · 07-01-2009, 09:56 AM

Thanks Sweep,

I thought I might have to use VBA which was what I was hoping to avoid on this ocassion. Thanks anyway.

RunHard

Data Validation Information Alert

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Data Validation Information Alert

Re: Data Validation Information Alert

Re: Data Validation Information Alert

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions