Macro code to set textbox caption

[m_woolf]

Can someone supply a code snippet that will set the caption to a textbox?

Thanks in acvance for your help.

[kaushiknsolanki · Accepted solution]

HI,

    This is the macro to set the caption for textbox.

set mybox = ActiveDocument.GetSheetObject("TX29")   /// here TX29 is object ID for the textbox.

set mbp = mybox.GetProperties

mbp.Layout.Frame.Name.v = "abc"

mybox.SetProperties mbp

Regards,

Kaushik Solanki

[#3]

I'd like to set the caption of a chart like this, but unfortunately the code above doesn't work. It does work for a text box but if I put in the object ID for a chart with the same code it fails. Do you know why?