get value from cell?

P

Pista

Hello,

I don't know how to get a value from a specific cell (Formula) in ShapeSheet.

shpText = shpObj.Cells("Prop._VisDM_Title").??? and here I would expect some
method like getText() or something like that, is it possible to get the
string value?

Thanks a lot and have a good day.
 
J

John Goldsmith

Hello Pista,

Similar to before, but this time it's ResultStr(""), which returns a cells
value as a string:

shpText = shpObj.Cells("Prop._VisDM_Title").ResultStr("")

Best regards

John

John Goldsmith
www.visualSignals.co.uk
 
P

Pista

Fantastic!

Thank you very much John,

Pista


John Goldsmith said:
Hello Pista,

Similar to before, but this time it's ResultStr(""), which returns a cells
value as a string:

shpText = shpObj.Cells("Prop._VisDM_Title").ResultStr("")

Best regards

John

John Goldsmith
www.visualSignals.co.uk
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cells() returning wrong cell? 3
Drop down list control value in vba 2
List all tables, including document structure 0
connections of a shape, and which shape they come from / go to 0
(VBA) Get String from Width Property 1
A couple questions BEFORE using Office 365 0
Bug: ShapeSheet Protection values not getting recalculated properl 3
problems getting this macro to work 8

Top