topic Setting lable for multibox field using macro in QlikView https://community.qlik.com/t5/QlikView/Setting-lable-for-multibox-field-using-macro/m-p/273977#M1203173 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>i have problem with changing lable for one of multibox fields. I need macro for this job. I know it is only several lines but I new at this.</P><P></P><P>set multibox = ActiveDocument.getSheetObject("MB43")</P><P>multibox.AddField "cat2_name_EN"</P><P>......(added field lable)....</P></BODY></HTML> Wed, 01 Sep 2010 14:56:49 GMT 2010-09-01T14:56:49Z Setting lable for multibox field using macro https://community.qlik.com/t5/QlikView/Setting-lable-for-multibox-field-using-macro/m-p/273977#M1203173 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>i have problem with changing lable for one of multibox fields. I need macro for this job. I know it is only several lines but I new at this.</P><P></P><P>set multibox = ActiveDocument.getSheetObject("MB43")</P><P>multibox.AddField "cat2_name_EN"</P><P>......(added field lable)....</P></BODY></HTML> Wed, 01 Sep 2010 14:56:49 GMT https://community.qlik.com/t5/QlikView/Setting-lable-for-multibox-field-using-macro/m-p/273977#M1203173 2010-09-01T14:56:49Z Setting lable for multibox field using macro https://community.qlik.com/t5/QlikView/Setting-lable-for-multibox-field-using-macro/m-p/273978#M1203174 <HTML><HEAD></HEAD><BODY><P>Do you NEED to use a macro? If I'm understanding what you're asking, you might be able to accomplish the same thing by just using an expression for the field's label. That would be cleaner if it would work for you.</P></BODY></HTML> Thu, 02 Sep 2010 01:08:03 GMT https://community.qlik.com/t5/QlikView/Setting-lable-for-multibox-field-using-macro/m-p/273978#M1203174 johnw 2010-09-02T01:08:03Z Setting lable for multibox field using macro https://community.qlik.com/t5/QlikView/Setting-lable-for-multibox-field-using-macro/m-p/273979#M1203175 <HTML><HEAD></HEAD><BODY><P>Yes I know. But I need macro because I am adding and removing fields from my multibox using macro and my field's label disappears.</P></BODY></HTML> Thu, 02 Sep 2010 05:58:46 GMT https://community.qlik.com/t5/QlikView/Setting-lable-for-multibox-field-using-macro/m-p/273979#M1203175 2010-09-02T05:58:46Z Setting lable for multibox field using macro https://community.qlik.com/t5/QlikView/Setting-lable-for-multibox-field-using-macro/m-p/273980#M1203176 <HTML><HEAD></HEAD><BODY><P>I found my answer :<IMG alt="Big Smile" src="http://community.qlik.com/emoticons/emotion-2.gif" /></P><P></P><P></P><P></P><P></P><BR /><BR /> <P></P><P>set multibox = ActiveDocument.getSheetObject("MB42")</P><P></P><P style="margin:0cm 0cm 10pt;">multibox.AddField "cat1_name_EN"</P><P style="margin:0cm 0cm 10pt;">mbp = multibox.GetProperties</P><P style="margin:0cm 0cm 10pt;">mbp.MemberAttributes.Item(0).Label.v = "Class description"</P><P style="margin:0cm 0cm 10pt;">multibox.SetProperties mbp</P><BR /><BR /> <P style="margin:0cm 0cm 10pt;">Thank you for help and time <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P></P><P></P><BR /><BR /> <P></P><P></P><BR /><BR /> <BR /><BR /> <P></P><P></P><P></P><P></P><P></P><BR /><BR /> <P></P><P></P><BR /><BR /></BODY></HTML> Thu, 02 Sep 2010 07:35:57 GMT https://community.qlik.com/t5/QlikView/Setting-lable-for-multibox-field-using-macro/m-p/273980#M1203176 2010-09-02T07:35:57Z Setting lable for multibox field using macro https://community.qlik.com/t5/QlikView/Setting-lable-for-multibox-field-using-macro/m-p/273981#M1203177 <HTML><HEAD></HEAD><BODY><P>Ah, OK. Now I see why you needed it to be in a macro. Glad you were able to figure it out. <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Fri, 03 Sep 2010 01:20:09 GMT https://community.qlik.com/t5/QlikView/Setting-lable-for-multibox-field-using-macro/m-p/273981#M1203177 johnw 2010-09-03T01:20:09Z