| 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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
target.value
Will enclose code I am useing. Target in end will be text entered in a cell
on another sheet. Then you move out of cell and then click on an option button which pastes that cell back into main sheet. I know I have (0) in there this is trying to get it to trigger. Have not used text to trigger before. As your post CDbl is new to me. Have been having trouble with IsText when compileing.any way heres the code that I have done something wrong with Thanks for looking If Target.Column = 12 And Target.Value 1 And IsNumeric(Target.Value) Then _ Call Announcer(Target) Public Sub Announcer(ByVal Target As Range) Dim wksSummary As Worksheet Dim rngPaste As Range Set wksSummary = Sheets("Announcer") Set rngPaste = wksSummary.Cells(65536, "A").End(xlUp).Offset(1, 0) Application.EnableEvents = False Set rngPaste = rngPaste.Offset(0, 0) Union(Target.Offset(0, -11), Target.Offset(0, 8), _ Target.Offset(0, 7), Target.Offset(0, 5), _ Target).Copy Destination:=rngPaste rngPaste.Offset(0, 7) = Target Application.EnableEvents = True End Sub "Bernie Deitrick" wrote: 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 | |||
Linear Mode
