Thread: POP up Box
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Seanie Seanie is offline
external usenet poster
 
Posts: 202
Default POP up Box

My attempt was this but nothing happens!

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If .Range("T10").Value = "Error" Then
MsgBox "You have not entered the correct Opening value, please
review and re-enter (see previous days closing value)"

Sheets("Figures").Select
Range("B5").Select

Exit Sub
End If

End Sub