LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 469
Default 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)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Trigger a Macro Patrick Simonds Excel Programming 1 December 16th 06 07:28 AM
add text in a cell to trigger a calculation noddy47 Excel Worksheet Functions 3 October 24th 06 09:02 AM
Functions Trigger Frankie Excel Programming 6 May 26th 06 03:11 PM
trigger help climax Excel Worksheet Functions 1 February 2nd 06 04:39 PM
Row Deletion Using Text Trigger? daved Excel Programming 1 July 15th 03 04:23 AM


All times are GMT +1. The time now is 12:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"