Pop up Message box

[klynne75]

I'm trying to create a popup messgage box based on a cell value in a worksheet.

I have multiple worksheets in my workbook.

In my 1st worksheet "Bridger" I'd like a pop up box to appear when/if AE3<=AE4. The message will say "Time to order tickets".

The remaining worksheets will have similar messages but the cell ranges will be different.

I've never written code before, so I'm clueless.

Are there any links that would teach me more?

 

[kevin lazell]

i think this will do what you need


Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Range("ae3") <= Range("ae4") Then
MsgBox ("time to order tickets"), vbOKOnly
End If
End Sub

right click on the sheet tab select view code and paste there
cheers kev

 

[klynne75]

That works! Thanks!