text trigger
 

have not been able to get text to function as trigger
Useing following have compile problem useing IsText say wrong argument
Have no trouble when useing numeric value.
Target column 12 will all ways have text in it. It is description cell
stimmed.
Thanks

< = 0
also no go
If Target.Column = 12 And CDbl(Target.Value) (" ") And
IsText(Target.Value) Then _
Call Announcer(Target)

text trigger
 

Is IsText a user defined function?

You'll also get a type mismatch error on this one:

CDbl(Target.Value) (" ")

Is this what you're trying to do? :

If Target.Column = 12 And CDbl(Target.Value) 0 Then Call Announcer(Target)


--
Hope that helps.

Vergel Adriano


"Curt" wrote:

have not been able to get text to function as trigger
Useing following have compile problem useing IsText say wrong argument
Have no trouble when useing numeric value.
Target column 12 will all ways have text in it. It is description cell
stimmed.
Thanks

< = 0
also no go
If Target.Column = 12 And CDbl(Target.Value) (" ") And
IsText(Target.Value) Then _
Call Announcer(Target)

text trigger
 

Perhaps

With Target
If .Column = 12 Then _
If Application.IsText(.Value) Then _
If Len(Trim(.Text)) 0 Then _
Call Announcer(.Cells)
End With

In article ,
Curt wrote:

have not been able to get text to function as trigger
Useing following have compile problem useing IsText say wrong argument
Have no trouble when useing numeric value.
Target column 12 will all ways have text in it. It is description cell
stimmed.
Thanks

< = 0
also no go
If Target.Column = 12 And CDbl(Target.Value) (" ") And
IsText(Target.Value) Then _
Call Announcer(Target)

text trigger
 

Thanks Much

"Vergel Adriano" wrote:

Is IsText a user defined function?

You'll also get a type mismatch error on this one:

CDbl(Target.Value) (" ")

Is this what you're trying to do? :

If Target.Column = 12 And CDbl(Target.Value) 0 Then Call Announcer(Target)


--
Hope that helps.

Vergel Adriano


"Curt" wrote:

have not been able to get text to function as trigger
Useing following have compile problem useing IsText say wrong argument
Have no trouble when useing numeric value.
Target column 12 will all ways have text in it. It is description cell
stimmed.
Thanks

< = 0
also no go
If Target.Column = 12 And CDbl(Target.Value) (" ") And
IsText(Target.Value) Then _
Call Announcer(Target)

text trigger
 

Belive it or not I got it by this

If Target.Column = 12 And Target.Value (" ") Then _
Call Announcer(Target)
Simple once you find it
Thanks


"JE McGimpsey" wrote:

Perhaps

With Target
If .Column = 12 Then _
If Application.IsText(.Value) Then _
If Len(Trim(.Text)) 0 Then _
Call Announcer(.Cells)
End With

In article ,
Curt wrote:

have not been able to get text to function as trigger
Useing following have compile problem useing IsText say wrong argument
Have no trouble when useing numeric value.
Target column 12 will all ways have text in it. It is description cell
stimmed.
Thanks

< = 0
also no go
If Target.Column = 12 And CDbl(Target.Value) (" ") And
IsText(Target.Value) Then _
Call Announcer(Target)

text trigger
 

That'll work unless the user enters two or more space characters.

In article ,
Curt wrote:

Belive it or not I got it by this

If Target.Column = 12 And Target.Value (" ") Then _
Call Announcer(Target)
Simple once you find it
Thanks

text trigger
 

Thanks for the update

"JE McGimpsey" wrote:

That'll work unless the user enters two or more space characters.

In article ,
Curt wrote:

Belive it or not I got it by this

If Target.Column = 12 And Target.Value (" ") Then _
Call Announcer(Target)
Simple once you find it
Thanks