please help
 

can I make the word grading tractor show on my sheet but holds the value of
$80?

if so How can i do it?

please help
 

This is just a guess, but of you had a drawing toolbar textbox named Word
Grading Tractor, this would work.

Sub ShowWordGradingTractor()
With ActiveSheet.Shapes("Word Grading Tractor")
.TextFrame.Characters.Text = "$80"
.Visible = True
End With
End Sub

Perhaps another attempt at describing what you want.

--
Regards,
Tom Ogilvy


"
.com wrote in message
...
can I make the word grading tractor show on my sheet but holds the value
of
$80?

if so How can i do it?

please help
 

Elisa,

Am not sure what you are asking for.

I did enter "grading tractor" into a cell.
Than I went to insert name (with the cell still selected)
The dialong suggested that the name be: "grading_tractor"
In the refers to box I put : "=80"
(the quotes are mine and you shouldn't use them)

In another cell I put: "=grading_tractor"
and the cell showed the value 80

???

--
steveB

Remove "AYN" from email to respond
"
.com wrote in message
...
can I make the word grading tractor show on my sheet but holds the value
of
$80?

if so How can i do it?

please help
 

Sub EFG()
Dim nme As Name
Set nme = ThisWorkbook.Names.Add(Name:="Grading_Factor", _
RefersTo:="=""$80""")
ActiveCell.Formula = "=Grading_Factor"

End Sub

or

Sub EFG()
Dim nme As Name
Set nme = ThisWorkbook.Names.Add(Name:="Grading_Factor", _
RefersTo:="=$80")
ActiveCell.Formula = "=Grading_Factor"
ActiveCell.Numberformat = "$#,###"

End Sub

--
Regards,
Tom Ogilvy



"STEVE BELL" wrote in message
news:fmV2f.14661$Tn5.11076@trnddc08...
Elisa,

Am not sure what you are asking for.

I did enter "grading tractor" into a cell.
Than I went to insert name (with the cell still selected)
The dialong suggested that the name be: "grading_tractor"
In the refers to box I put : "=80"
(the quotes are mine and you shouldn't use them)

In another cell I put: "=grading_tractor"
and the cell showed the value 80

???

--
steveB

Remove "AYN" from email to respond
"
.com wrote in message
...
can I make the word grading tractor show on my sheet but holds the value
of
$80?

if so How can i do it?

please help
 

OK I GOT THAT PART THANK YOU......... =SUM(GRADING_TRACTOR*E3)

KEEP IN MIND THAT I ENTER GRADING TRACTOR IN CELL A1.
CELL E3 HAS THE NUMBER 8 AND CELL F3 HAS THE ABOVE FORMULA.

NOW IF I CHANGE CELL A1 FROM A GRADING TRACTOR TO LABOR WITH THE VALUE OF
($28) HOW CAN I MAKE MY FORMULA IN CALL F3 DISTINGUISH THAT WITH OUT HAVE TO
CHANGE THE FORMULA MANUALLY.

THANK YOU VERY MUCH

"STEVE BELL" wrote:

Elisa,

Am not sure what you are asking for.

I did enter "grading tractor" into a cell.
Than I went to insert name (with the cell still selected)
The dialong suggested that the name be: "grading_tractor"
In the refers to box I put : "=80"
(the quotes are mine and you shouldn't use them)

In another cell I put: "=grading_tractor"
and the cell showed the value 80

???

--
steveB

Remove "AYN" from email to respond
"
.com wrote in message
...
can I make the word grading tractor show on my sheet but holds the value
of
$80?

if so How can i do it?

please help
 

Insert = Name = Define
Name: Grading_Tractor
RefersTo: =Sheet1!$A$1

Click the Add button.

--
Regards,
Tom Ogilvy

"
.com wrote in message
...
OK I GOT THAT PART THANK YOU......... =SUM(GRADING_TRACTOR*E3)

KEEP IN MIND THAT I ENTER GRADING TRACTOR IN CELL A1.
CELL E3 HAS THE NUMBER 8 AND CELL F3 HAS THE ABOVE FORMULA.

NOW IF I CHANGE CELL A1 FROM A GRADING TRACTOR TO LABOR WITH THE VALUE OF
($28) HOW CAN I MAKE MY FORMULA IN CALL F3 DISTINGUISH THAT WITH OUT HAVE
TO
CHANGE THE FORMULA MANUALLY.

THANK YOU VERY MUCH

"STEVE BELL" wrote:

Elisa,

Am not sure what you are asking for.

I did enter "grading tractor" into a cell.
Than I went to insert name (with the cell still selected)
The dialong suggested that the name be: "grading_tractor"
In the refers to box I put : "=80"
(the quotes are mine and you shouldn't use them)

In another cell I put: "=grading_tractor"
and the cell showed the value 80

???

--
steveB

Remove "AYN" from email to respond
"
.com wrote in message
...
can I make the word grading tractor show on my sheet but holds the
value
of
$80?

if so How can i do it?

please help
 

i'm not good enough to write a function, but wouldn't a function do this

If Range("a1") = "grading_tractor" Then
icost = 80
Else
If Range("a1") = "labor" Then
icost = 28

then the formula in f3 could be = icost*whatever
--


Gary


"Tom Ogilvy" wrote in message
...
Insert = Name = Define
Name: Grading_Tractor
RefersTo: =Sheet1!$A$1

Click the Add button.

--
Regards,
Tom Ogilvy

"
.com wrote in message
...
OK I GOT THAT PART THANK YOU......... =SUM(GRADING_TRACTOR*E3)

KEEP IN MIND THAT I ENTER GRADING TRACTOR IN CELL A1.
CELL E3 HAS THE NUMBER 8 AND CELL F3 HAS THE ABOVE FORMULA.

NOW IF I CHANGE CELL A1 FROM A GRADING TRACTOR TO LABOR WITH THE VALUE OF
($28) HOW CAN I MAKE MY FORMULA IN CALL F3 DISTINGUISH THAT WITH OUT HAVE
TO
CHANGE THE FORMULA MANUALLY.

THANK YOU VERY MUCH

"STEVE BELL" wrote:

Elisa,

Am not sure what you are asking for.

I did enter "grading tractor" into a cell.
Than I went to insert name (with the cell still selected)
The dialong suggested that the name be: "grading_tractor"
In the refers to box I put : "=80"
(the quotes are mine and you shouldn't use them)

In another cell I put: "=grading_tractor"
and the cell showed the value 80

???

--
steveB

Remove "AYN" from email to respond
"
.com wrote in
message
...
can I make the word grading tractor show on my sheet but holds the
value
of
$80?

if so How can i do it?

please help
 

Hi Gary

can you please lead me step by step in how and where to enter that function

thank you

"Gary Keramidas" wrote:

i'm not good enough to write a function, but wouldn't a function do this

If Range("a1") = "grading_tractor" Then
icost = 80
Else
If Range("a1") = "labor" Then
icost = 28

then the formula in f3 could be = icost*whatever
--


Gary


"Tom Ogilvy" wrote in message
...
Insert = Name = Define
Name: Grading_Tractor
RefersTo: =Sheet1!$A$1

Click the Add button.

--
Regards,
Tom Ogilvy

"
.com wrote in message
...
OK I GOT THAT PART THANK YOU......... =SUM(GRADING_TRACTOR*E3)

KEEP IN MIND THAT I ENTER GRADING TRACTOR IN CELL A1.
CELL E3 HAS THE NUMBER 8 AND CELL F3 HAS THE ABOVE FORMULA.

NOW IF I CHANGE CELL A1 FROM A GRADING TRACTOR TO LABOR WITH THE VALUE OF
($28) HOW CAN I MAKE MY FORMULA IN CALL F3 DISTINGUISH THAT WITH OUT HAVE
TO
CHANGE THE FORMULA MANUALLY.

THANK YOU VERY MUCH

"STEVE BELL" wrote:

Elisa,

Am not sure what you are asking for.

I did enter "grading tractor" into a cell.
Than I went to insert name (with the cell still selected)
The dialong suggested that the name be: "grading_tractor"
In the refers to box I put : "=80"
(the quotes are mine and you shouldn't use them)

In another cell I put: "=grading_tractor"
and the cell showed the value 80

???

--
steveB

Remove "AYN" from email to respond
"
.com wrote in
message
...
can I make the word grading tractor show on my sheet but holds the
value
of
$80?

if so How can i do it?

please help
 

See latest thread by Elisa to see even more guesses.

--
Regards,
Tom Ogilvy

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
i'm not good enough to write a function, but wouldn't a function do this

If Range("a1") = "grading_tractor" Then
icost = 80
Else
If Range("a1") = "labor" Then
icost = 28

then the formula in f3 could be = icost*whatever
--


Gary


"Tom Ogilvy" wrote in message
...
Insert = Name = Define
Name: Grading_Tractor
RefersTo: =Sheet1!$A$1

Click the Add button.

--
Regards,
Tom Ogilvy

"
.com wrote in message
...
OK I GOT THAT PART THANK YOU......... =SUM(GRADING_TRACTOR*E3)

KEEP IN MIND THAT I ENTER GRADING TRACTOR IN CELL A1.
CELL E3 HAS THE NUMBER 8 AND CELL F3 HAS THE ABOVE FORMULA.

NOW IF I CHANGE CELL A1 FROM A GRADING TRACTOR TO LABOR WITH THE VALUE
OF
($28) HOW CAN I MAKE MY FORMULA IN CALL F3 DISTINGUISH THAT WITH OUT
HAVE
TO
CHANGE THE FORMULA MANUALLY.

THANK YOU VERY MUCH

"STEVE BELL" wrote:

Elisa,

Am not sure what you are asking for.

I did enter "grading tractor" into a cell.
Than I went to insert name (with the cell still selected)
The dialong suggested that the name be: "grading_tractor"
In the refers to box I put : "=80"
(the quotes are mine and you shouldn't use them)

In another cell I put: "=grading_tractor"
and the cell showed the value 80

???

--
steveB

Remove "AYN" from email to respond
"
.com wrote in
message
...
can I make the word grading tractor show on my sheet but holds the
value
of
$80?

if so How can i do it?

please help
 

if i wanted a function for this, could it be done?

--


Gary


"Tom Ogilvy" wrote in message
...
See latest thread by Elisa to see even more guesses.

--
Regards,
Tom Ogilvy

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
i'm not good enough to write a function, but wouldn't a function do this

If Range("a1") = "grading_tractor" Then
icost = 80
Else
If Range("a1") = "labor" Then
icost = 28

then the formula in f3 could be = icost*whatever
--


Gary


"Tom Ogilvy" wrote in message
...
Insert = Name = Define
Name: Grading_Tractor
RefersTo: =Sheet1!$A$1

Click the Add button.

--
Regards,
Tom Ogilvy

"
.com wrote in
message
...
OK I GOT THAT PART THANK YOU......... =SUM(GRADING_TRACTOR*E3)

KEEP IN MIND THAT I ENTER GRADING TRACTOR IN CELL A1.
CELL E3 HAS THE NUMBER 8 AND CELL F3 HAS THE ABOVE FORMULA.

NOW IF I CHANGE CELL A1 FROM A GRADING TRACTOR TO LABOR WITH THE VALUE
OF
($28) HOW CAN I MAKE MY FORMULA IN CALL F3 DISTINGUISH THAT WITH OUT
HAVE
TO
CHANGE THE FORMULA MANUALLY.

THANK YOU VERY MUCH

"STEVE BELL" wrote:

Elisa,

Am not sure what you are asking for.

I did enter "grading tractor" into a cell.
Than I went to insert name (with the cell still selected)
The dialong suggested that the name be: "grading_tractor"
In the refers to box I put : "=80"
(the quotes are mine and you shouldn't use them)

In another cell I put: "=grading_tractor"
and the cell showed the value 80

???

--
steveB

Remove "AYN" from email to respond
"
.com wrote in
message
...
can I make the word grading tractor show on my sheet but holds the
value
of
$80?

if so How can i do it?

please help
 

If your talking about a UDF, I don't see any problem. You basically laid
out a structure for one - depending on the interpretation of what "this" is
that the OP is trying to do.

--
Regards,
Tom Ogilvy

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
if i wanted a function for this, could it be done?

--


Gary


"Tom Ogilvy" wrote in message
...
See latest thread by Elisa to see even more guesses.

--
Regards,
Tom Ogilvy

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
i'm not good enough to write a function, but wouldn't a function do
this

If Range("a1") = "grading_tractor" Then
icost = 80
Else
If Range("a1") = "labor" Then
icost = 28

then the formula in f3 could be = icost*whatever
--


Gary


"Tom Ogilvy" wrote in message
...
Insert = Name = Define
Name: Grading_Tractor
RefersTo: =Sheet1!$A$1

Click the Add button.

--
Regards,
Tom Ogilvy

"
.com wrote in
message
...
OK I GOT THAT PART THANK YOU......... =SUM(GRADING_TRACTOR*E3)

KEEP IN MIND THAT I ENTER GRADING TRACTOR IN CELL A1.
CELL E3 HAS THE NUMBER 8 AND CELL F3 HAS THE ABOVE FORMULA.

NOW IF I CHANGE CELL A1 FROM A GRADING TRACTOR TO LABOR WITH THE
VALUE
OF
($28) HOW CAN I MAKE MY FORMULA IN CALL F3 DISTINGUISH THAT WITH OUT
HAVE
TO
CHANGE THE FORMULA MANUALLY.

THANK YOU VERY MUCH

"STEVE BELL" wrote:

Elisa,

Am not sure what you are asking for.

I did enter "grading tractor" into a cell.
Than I went to insert name (with the cell still selected)
The dialong suggested that the name be: "grading_tractor"
In the refers to box I put : "=80"
(the quotes are mine and you shouldn't use them)

In another cell I put: "=grading_tractor"
and the cell showed the value 80

???

--
steveB

Remove "AYN" from email to respond
"
.com wrote in
message
...
can I make the word grading tractor show on my sheet but holds
the
value
of
$80?

if so How can i do it?

please help
 

yes, a udf. i just wondered how to do it. i laid out the part that seemed
obvious, but i would have no idea what the 1st line would be.

--


Gary


"Tom Ogilvy" wrote in message
...
If your talking about a UDF, I don't see any problem. You basically laid
out a structure for one - depending on the interpretation of what "this"
is
that the OP is trying to do.

--
Regards,
Tom Ogilvy

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
if i wanted a function for this, could it be done?

--


Gary


"Tom Ogilvy" wrote in message
...
See latest thread by Elisa to see even more guesses.

--
Regards,
Tom Ogilvy

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
i'm not good enough to write a function, but wouldn't a function do
this

If Range("a1") = "grading_tractor" Then
icost = 80
Else
If Range("a1") = "labor" Then
icost = 28

then the formula in f3 could be = icost*whatever
--


Gary


"Tom Ogilvy" wrote in message
...
Insert = Name = Define
Name: Grading_Tractor
RefersTo: =Sheet1!$A$1

Click the Add button.

--
Regards,
Tom Ogilvy

"
.com wrote in
message
...
OK I GOT THAT PART THANK YOU......... =SUM(GRADING_TRACTOR*E3)

KEEP IN MIND THAT I ENTER GRADING TRACTOR IN CELL A1.
CELL E3 HAS THE NUMBER 8 AND CELL F3 HAS THE ABOVE FORMULA.

NOW IF I CHANGE CELL A1 FROM A GRADING TRACTOR TO LABOR WITH THE
VALUE
OF
($28) HOW CAN I MAKE MY FORMULA IN CALL F3 DISTINGUISH THAT WITH
OUT
HAVE
TO
CHANGE THE FORMULA MANUALLY.

THANK YOU VERY MUCH

"STEVE BELL" wrote:

Elisa,

Am not sure what you are asking for.

I did enter "grading tractor" into a cell.
Than I went to insert name (with the cell still selected)
The dialong suggested that the name be: "grading_tractor"
In the refers to box I put : "=80"
(the quotes are mine and you shouldn't use them)

In another cell I put: "=grading_tractor"
and the cell showed the value 80

???

--
steveB

Remove "AYN" from email to respond
"
.com wrote in
message
...
can I make the word grading tractor show on my sheet but holds
the
value
of
$80?

if so How can i do it?

please help
 

Public Function Icost(rng as Range)
sStr = lcase(rng(1).Value)
If sStr = "grading tractor" Then
icost = 80
Else If sStr = "labor" Then
icost = 28
Else
icost = 0
End if
End Function

to make your function recalculate, you should put the dependencies in the
argument of the function. So this would be used

=Icost(A1)*E3

Now if A1 is changed, the formula would recalculate.
the function should be place in a general module, not a sheet or the
thisworkbook module

--
Regards,
Tom Ogilvy


"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
yes, a udf. i just wondered how to do it. i laid out the part that seemed
obvious, but i would have no idea what the 1st line would be.

--


Gary


"Tom Ogilvy" wrote in message
...
If your talking about a UDF, I don't see any problem. You basically
laid
out a structure for one - depending on the interpretation of what "this"
is
that the OP is trying to do.

--
Regards,
Tom Ogilvy

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
if i wanted a function for this, could it be done?

--


Gary


"Tom Ogilvy" wrote in message
...
See latest thread by Elisa to see even more guesses.

--
Regards,
Tom Ogilvy

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
i'm not good enough to write a function, but wouldn't a function do
this

If Range("a1") = "grading_tractor" Then
icost = 80
Else
If Range("a1") = "labor" Then
icost = 28

then the formula in f3 could be = icost*whatever
--


Gary


"Tom Ogilvy" wrote in message
...
Insert = Name = Define
Name: Grading_Tractor
RefersTo: =Sheet1!$A$1

Click the Add button.

--
Regards,
Tom Ogilvy

"
.com wrote in
message
...
OK I GOT THAT PART THANK YOU......... =SUM(GRADING_TRACTOR*E3)

KEEP IN MIND THAT I ENTER GRADING TRACTOR IN CELL A1.
CELL E3 HAS THE NUMBER 8 AND CELL F3 HAS THE ABOVE FORMULA.

NOW IF I CHANGE CELL A1 FROM A GRADING TRACTOR TO LABOR WITH THE
VALUE
OF
($28) HOW CAN I MAKE MY FORMULA IN CALL F3 DISTINGUISH THAT WITH
OUT
HAVE
TO
CHANGE THE FORMULA MANUALLY.

THANK YOU VERY MUCH

"STEVE BELL" wrote:

Elisa,

Am not sure what you are asking for.

I did enter "grading tractor" into a cell.
Than I went to insert name (with the cell still selected)
The dialong suggested that the name be: "grading_tractor"
In the refers to box I put : "=80"
(the quotes are mine and you shouldn't use them)

In another cell I put: "=grading_tractor"
and the cell showed the value 80

???

--
steveB

Remove "AYN" from email to respond
"
.com wrote
in
message
...
can I make the word grading tractor show on my sheet but
holds
the
value
of
$80?

if so How can i do it?