#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 469
Default target.value

= isText
If Target.Column = 12 And Target.Value <= 0 And IsText(Target.Value) Then _
Call Announcer(Target)
used to working with numeric blanked on this text issue
isText was isNumeric
does this look right
Thanks
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,441
Default target.value

Curt,

Your comparison

Target.Value <= 0

will get you in trouble, if target.value is actually text. Try:

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


HTH,
Bernie
MS Excel MVP


"Curt" wrote in message
...
= isText
If Target.Column = 12 And Target.Value <= 0 And IsText(Target.Value) Then _
Call Announcer(Target)
used to working with numeric blanked on this text issue
isText was isNumeric
does this look right
Thanks



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 469
Default target.value

Thanks
One more question. The target cell should all ways be text. Is there any
other change I should use?
Sure appreciate the responce

"Bernie Deitrick" wrote:

Curt,

Your comparison

Target.Value <= 0

will get you in trouble, if target.value is actually text. Try:

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


HTH,
Bernie
MS Excel MVP


"Curt" wrote in message
...
= isText
If Target.Column = 12 And Target.Value <= 0 And IsText(Target.Value) Then _
Call Announcer(Target)
used to working with numeric blanked on this text issue
isText was isNumeric
does this look right
Thanks




  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,441
Default target.value

Curt,

It depends on what your target values are. Are they strings that look like
numbers? Some examples of what you expect would help...

Bernie


"Curt" wrote in message
...
Thanks
One more question. The target cell should all ways be text. Is there any
other change I should use?
Sure appreciate the responce

"Bernie Deitrick" wrote:

Curt,

Your comparison

Target.Value <= 0

will get you in trouble, if target.value is actually text. Try:

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


HTH,
Bernie
MS Excel MVP


"Curt" wrote in message
...
= isText
If Target.Column = 12 And Target.Value <= 0 And IsText(Target.Value)
Then _
Call Announcer(Target)
used to working with numeric blanked on this text issue
isText was isNumeric
does this look right
Thanks






  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 469
Default target.value

No nbrs. will all ways be text as it is as describtion of entry
Thanks

"Bernie Deitrick" wrote:

Curt,

It depends on what your target values are. Are they strings that look like
numbers? Some examples of what you expect would help...

Bernie


"Curt" wrote in message
...
Thanks
One more question. The target cell should all ways be text. Is there any
other change I should use?
Sure appreciate the responce

"Bernie Deitrick" wrote:

Curt,

Your comparison

Target.Value <= 0

will get you in trouble, if target.value is actually text. Try:

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


HTH,
Bernie
MS Excel MVP


"Curt" wrote in message
...
= isText
If Target.Column = 12 And Target.Value <= 0 And IsText(Target.Value)
Then _
Call Announcer(Target)
used to working with numeric blanked on this text issue
isText was isNumeric
does this look right
Thanks








  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 469
Default target.value

no nbrs will all ways be text. the text is entered into a cell on another
sheet then pasted back to the target cell it is shrunk to fit.
Horse drawn carriage Fire truck etc. Can not expect to have any resemblance
to nbrs.
Better desc I hope.
Thanks

"Bernie Deitrick" wrote:

Curt,

It depends on what your target values are. Are they strings that look like
numbers? Some examples of what you expect would help...

Bernie


"Curt" wrote in message
...
Thanks
One more question. The target cell should all ways be text. Is there any
other change I should use?
Sure appreciate the responce

"Bernie Deitrick" wrote:

Curt,

Your comparison

Target.Value <= 0

will get you in trouble, if target.value is actually text. Try:

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


HTH,
Bernie
MS Excel MVP


"Curt" wrote in message
...
= isText
If Target.Column = 12 And Target.Value <= 0 And IsText(Target.Value)
Then _
Call Announcer(Target)
used to working with numeric blanked on this text issue
isText was isNumeric
does this look right
Thanks






  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,441
Default target.value

Curt,

You need to explain the logic of your desired procedu y ou have a check
for the number being less than 0, so that obviously won't be applicable.

Bernie


"Curt" wrote in message
...
no nbrs will all ways be text. the text is entered into a cell on another
sheet then pasted back to the target cell it is shrunk to fit.
Horse drawn carriage Fire truck etc. Can not expect to have any
resemblance
to nbrs.
Better desc I hope.
Thanks

"Bernie Deitrick" wrote:

Curt,

It depends on what your target values are. Are they strings that look
like
numbers? Some examples of what you expect would help...

Bernie


"Curt" wrote in message
...
Thanks
One more question. The target cell should all ways be text. Is there
any
other change I should use?
Sure appreciate the responce

"Bernie Deitrick" wrote:

Curt,

Your comparison

Target.Value <= 0

will get you in trouble, if target.value is actually text. Try:

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


HTH,
Bernie
MS Excel MVP


"Curt" wrote in message
...
= isText
If Target.Column = 12 And Target.Value <= 0 And IsText(Target.Value)
Then _
Call Announcer(Target)
used to working with numeric blanked on this text issue
isText was isNumeric
does this look right
Thanks








Reply
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
Target Question jkrist46 New Users to Excel 1 April 5th 06 06:08 AM
Target Question jkrist46 New Users to Excel 2 April 4th 06 08:06 PM
Target Param Excel Worksheet Functions 1 March 16th 06 08:13 PM
Target Cells Bohdon Excel Worksheet Functions 1 February 23rd 06 09:18 PM
From Target to Source Steved Excel Worksheet Functions 1 June 10th 05 05:28 AM


All times are GMT +1. The time now is 08:33 AM.

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

About Us

"It's about Microsoft Excel"