iLogic code to compose a string

[Anonymous]

Hi

I need a little help to build a string with some sheet size parameters.

I would like to have a string wich looks like : A0 (841 x 1189), created from activesheet.size, activesheet.width and activesheet.height.

Then I will place this text on the side of my border, in my drawing template.

Thanks 

[clutsa · Accepted solution]

Use "&" to concatenate strings together

iProperties.Value("Custom", "SheetLabel") = ActiveSheet.Size & " (" & ActiveSheet.Width & " x " & ActiveSheet.Height & ")"

make your text box reference your custom iProperty and BOOM your done.

[Anonymous]

Thank you very much