Essbase + Excel + VBA

[poppy]

Hi Experts

I hope you can help me. I am trying to populate a combobox with data
from an Essbase database. I have added the combobox to the sheet now I
just need to add the necessary data that the user can choose from. How
would I go about it?

I know how to do this in VB but I'm not sure about Essbase and VBA.

I would welcome any input.


Kind Regards

 

[Jim May]

Use Dynamic Range name:
In your Define Name Box (Control + F3) in the RefersTo: (box) enter
something like --

=OFFSET('Essbase-HotSheet'!$C$1,1,0,COUNTA('Essbase-HotSheet'!$C:$C)-1,1)

assign MyData in the Name box, Click ADD

Use Data Validation on cell where you want ComboBox -
Allow Select --->> List
In Source box enter =MyData
That should get you started...
HTH