Msgbox if cell contains text

Dobbo · Apr 24th, 2002, 03:12 AM

If cell F3 contains text I want a message box run, I can do this with a number but having problems if cell contains text.

Audiojoe · Apr 24th, 2002, 03:16 AM

Try:

If worksheets("sheetname").range("f3").value = "text" then
msgbox...

Audiojoe

Dobbo · Apr 24th, 2002, 03:28 AM

Not quite what I meant, cell F3 could contain any text not "text" the word. Basically if cell F3 contains any word I want a message box to run.

Audiojoe · Apr 24th, 2002, 03:42 AM

Here you go:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)

If Worksheets("sheet1").Range("f3").Value = "" Then
Exit Sub
Else
MsgBox ("An entry has been made")
End If

End Sub

Audiojoe

[ This Message was edited by: Audiojoe on 2002-04-24 02:42 ]

Dobbo · Apr 24th, 2002, 04:02 AM

Many Thanks sorted out the problem now. I had the extra problem that F3 cell was merged with G3 & H3 so I had to call the range as well.

Works perfectly now Thank you

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 24th, 2002, 03:12 AM	#1
Dobbo New Member Join Date: Apr 2002 Posts: 12	If cell F3 contains text I want a message box run, I can do this with a number but having problems if cell contains text.

Apr 24th, 2002, 03:16 AM	#2
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	Try: If worksheets("sheetname").range("f3").value = "text" then msgbox... Audiojoe

Apr 24th, 2002, 03:28 AM	#3
Dobbo New Member Join Date: Apr 2002 Posts: 12	Not quite what I meant, cell F3 could contain any text not "text" the word. Basically if cell F3 contains any word I want a message box to run.

Apr 24th, 2002, 03:42 AM	#4
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	Here you go: Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Worksheets("sheet1").Range("f3").Value = "" Then Exit Sub Else MsgBox ("An entry has been made") End If End Sub Audiojoe [ This Message was edited by: Audiojoe on 2002-04-24 02:42 ]

Apr 24th, 2002, 04:02 AM	#5
Dobbo New Member Join Date: Apr 2002 Posts: 12	Many Thanks sorted out the problem now. I had the extra problem that F3 cell was merged with G3 & H3 so I had to call the range as well. Works perfectly now Thank you