Trevor2002
Board Regular
- Joined
- Oct 23, 2002
- Messages
- 52
Hi
I need some help with some code for a message box. The code I am using is
If Range("Sheet1!A1") = 1 Then
Dim Msg, Style, Title
Msg = "You have entered a wrong value in cell A1"
Style = vbOkOnly
Title = "AC Mistake"
Response = MsgBox(Msg, Style, Title)
End If
This works ok but I need some code to insert that when the user clicks ok, the message box goes away and stays away even if the user does'nt change the value in cell A1
Thanks Trevor2002
This message was edited by Trevor2002 on 2002-10-24 17:41
I need some help with some code for a message box. The code I am using is
If Range("Sheet1!A1") = 1 Then
Dim Msg, Style, Title
Msg = "You have entered a wrong value in cell A1"
Style = vbOkOnly
Title = "AC Mistake"
Response = MsgBox(Msg, Style, Title)
End If
This works ok but I need some code to insert that when the user clicks ok, the message box goes away and stays away even if the user does'nt change the value in cell A1
Thanks Trevor2002
This message was edited by Trevor2002 on 2002-10-24 17:41