Skip to Content
Former Member
Jun 04, 2013 at 07:06 PM

In BPC 10 NW, how can I accept input thru list box(Is is a FORM control and it is not an ActiveX control)


Dear All,

In BPC 10 NW, I need to show DIM(say, Entity) members in a list box. When the user selects an entity, I need to show the report based on that DIM member ID.

I am able to do the above using EPMDimensionOverride(). But, for this, currently, I am using ActiveX's List Box. ActiveX list box does not look nice.

Instead, I want to the form's Combo box which looks nicer. When I tried that, I am not able to go to the VBA code's editor when I double-click the control. How can I do this? i.e. to use form's Combo box in the Excel report/input form.

Thanks in advance for the help.