reference to a cell within a string

[susan hayes]

I have written the following:

If [b2] = 5 Then [b3] = "blp(""GE Equity"",""Last Price"")"
Else [b3] = ""

giving me the wanted result: blp("GE Equity","Last Price")

My question is, lets say I would like to reference cell [b4] = IBM, in
order to replace GE in this string.

to give me the result: blp("IBM Equity","Last Price")

Thank you,

Susan

 

[Guest]

If [b2] = 5 Then [b3] = "blp(""" & "[b4] & " Equity"",""Last Price"")"

 

[Guest]

Yikes! Just noticed a typo.
should be:
"blp(""" & [b4] & " Equity"",""Last Price"")"

If [b2] = 5 Then [b3] = "blp(""" & "[b4] & " Equity"",""Last Price"")"

I have written the following:

If [b2] = 5 Then [b3] = "blp(""GE Equity"",""Last Price"")"
Else [b3] = ""

giving me the wanted result: blp("GE Equity","Last Price")

My question is, lets say I would like to reference cell [b4] = IBM, in
order to replace GE in this string.

to give me the result: blp("IBM Equity","Last Price")

Thank you,

Susan

 

[sulprobil]

Have a look at
http://www.sulprobil.com/html/early_warning_system.html

But I think now it is better to use ActiveX than bpl()
functions.

Kind regards,
sulprobil