Essbase + Excel + VBA
 

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


--
poppy
------------------------------------------------------------------------
poppy's Profile: http://www.excelforum.com/member.php...o&userid=11453
View this thread: http://www.excelforum.com/showthread...hreadid=277642

Essbase + Excel + VBA
 

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


"poppy" wrote in message
...

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


--
poppy
------------------------------------------------------------------------
poppy's Profile:
http://www.excelforum.com/member.php...o&userid=11453
View this thread: http://www.excelforum.com/showthread...hreadid=277642