| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Target Question | New Users to Excel | |||
| Target Question | New Users to Excel | |||
| Target | Excel Worksheet Functions | |||
| Target Cells | Excel Worksheet Functions | |||
| From Target to Source | Excel Worksheet Functions | |||
Hybrid Mode
