M
Moumoute83
Hi, I'd like a macro which let me store some values in my custom properties
of my shape. I have access into my Custom Properties cell but I'm not able to
store any value into it (exception error "#NAME?").
I successed with Size & Position ("Angle" cell) but not with Custom
Properties section.
Any suggestion ?
'-----------------------------------------------------
'My example :
If vsoShapes.Item(intCounter).Name = "shape1" Then
Set vsoCell = vsoShapes.Item(intCounter).Cells("Angle")
vsoCell.Formula = "90 deg" 'to store a new angle value (RESULT : it
works)
Set vsoCell = vsoShapes.Item(intCounter).CellsSRC(visSectionProp,
visRowProp, visCustPropsValue)
Debug.Print vsoCell.Formula 'This is the good value
vsoCell.Formula = "newargument" '(RESULT : error, even if I
try with "=newargument" because of the formula type)
End If
'-----------------------------------------------------
I tried to force formule too (GUARD mode or not), but it doesn't work anyways.
Thanks a lot for your help.
of my shape. I have access into my Custom Properties cell but I'm not able to
store any value into it (exception error "#NAME?").
I successed with Size & Position ("Angle" cell) but not with Custom
Properties section.
Any suggestion ?
'-----------------------------------------------------
'My example :
If vsoShapes.Item(intCounter).Name = "shape1" Then
Set vsoCell = vsoShapes.Item(intCounter).Cells("Angle")
vsoCell.Formula = "90 deg" 'to store a new angle value (RESULT : it
works)
Set vsoCell = vsoShapes.Item(intCounter).CellsSRC(visSectionProp,
visRowProp, visCustPropsValue)
Debug.Print vsoCell.Formula 'This is the good value
vsoCell.Formula = "newargument" '(RESULT : error, even if I
try with "=newargument" because of the formula type)
End If
'-----------------------------------------------------
I tried to force formule too (GUARD mode or not), but it doesn't work anyways.
Thanks a lot for your help.